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.
LET
Assigns names to values or calculations to simplify formulas 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.
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).
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.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Grid Sum Generation
Challenge No. 142: Generate the result grid which is the sum of input grid.
Solved using: Python in Excel.
Next Palindrome Number
Challenge No. 141: Palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.
Common Letters Sorted
Challenge No. 140: List the common letters between Word1 and Word2 and sort them alphabetically.
Solved using: Power Query (List.Distinct, Table.AddColumn).
Multi Replacement!
Challenge No. 115:
Replace “q” and “000” in the Product ID and Customer ID columns with “-“.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Text.Replace, Table.ReplaceValue, Table.TransformColumns), Python, Python in Excel, R, SQL, and VBA.