Challenge No. 151: List the common digits between all the numbers in a row.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Perfect Numbers Detection
Challenge No. 149: List the perfect numbers from column A.
Solved using: Python in Excel.
Dso!
Challenge No. 118: Using the sales transactions from the provided table and the account balance as of 31/08/2024, calculate the Daily Sales Outstanding (DSO) for each customer.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
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.
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.
List Harshad Numbers
Challenge No. 143: List the numbers which are Harshad number (also known as Niven number or Multidigital number).
Solved using: Python in Excel.