Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.
List.Transform
Applies a function to each element in a list in Power Query.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Detect Possible Date Formats
Challenge No. 605: Out of 3 date formats only, MDY, DMY & YMD, list the date formats for given dates.
Solved using: Python.
Transpose table, compute gross profit
Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
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.