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.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
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.
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.
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.
Summarise the table with total
Challenge No. 266: Summarise the table as shown with a total row after each sales person’s data.
Solved using: Python.
Top Three Column Products
Challenge No. 578: Find the top 3 max product from the combination of numbers from 3 columns (Number1, Number2, Number3).
Solved using: Python.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.
