Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
VSTACK
Stacks arrays vertically into a single column in Excel.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Calculate Monthly Day Totals
Challenge No. 595: This challenge is contributed by 🇰🇷 Taeyong Shin
Create a table that calculates the number of weekdays, Saturdays, and Sundays using yearly and monthly data, and displays the total number of days in each month.
Solved using: Python in Excel.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Animal Park Presence Matrix
Challenge No. 586: List all animals and all parks.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.
Find Time Extremes by Date
Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.
Number Groups for Letter A
Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.
Work out tiered running totals
Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.