Challenge No. 621: Dear Patrons,
=LET(n,”72658080893278698732896965823250485053″,CONCAT(CHAR(MID(n,SEQUENCE(LEN(n)/2,,,2),2))))
Find out which dates are Palindromic dates in year 2025.
Solved using: Python.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.
Rank Cities by Percent Change
Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.
Extract Zip and Country Info
Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
Solved using: Python.
Calculate Red Highlighted Area
Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: Power Query.
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.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
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.
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.