Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Find Smallest Uncreatable Sum
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.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Match Words in Column Data
Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Sequential Group Numbering Logic
Challenge No. 596: This challenge is contributed by Ankur Sharma
Populate 1, 2, 3.
Solved using: Python.
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.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.