Challenge No. 148: Rotate the grid given in A4:E7 as per values given in B1.
Solved using: Power Query.
Check Narcissistic Numbers
Challenge No. 147: A Narcissistic number is that number which is the sum of nth powers of its digits where n is the length of the number.
Solved using: Python in Excel.
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Find Date Range Alphabetically
Challenge No. 41: Similar kind of problem appeared in MS Techcommunity and this is a variation of that.
Solved using: Excel VBA.
List All Pangram Sentences
Challenge No. 146: A Pangram (also known as Holoalphabetic) sentence is that which contains all 26 letters of English alphabets at least once.
Solved using: Power Query (Table.SelectRows).
Add Index Column! Part 3
Challenge No. 117: Add an Index column for the Question table with a separate counter for each stock.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (Table.AddIndexColumn, Table.Group, Table.Sort), Python, Python in Excel, and R.
Right Strip Given Chars
Challenge No. 145: Remove RSTRIP Chars from Input String from right side.
Solved using: SQL.
Match Acronyms with Words
Challenge No. 144: Match the Acronyms given in column C against the words given in column A.
Solved using: SQL.
Dynamic Pivot Data
Challenge No. 36: Create a dynamic solution to analyse tests per student
Minimize the steps/functions used
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Generate result table from the
Challenge No. 40: Generate the result table from the problem table as shown.
Solved using: Python.