Challenge No. 142: Generate the result grid which is the sum of input grid.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Next Palindrome Number
Challenge No. 141: Palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.
Calculate financial year running totals
Challenge No. 39: Calculate Running Total for all individuals.
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.
Vowel End and Start Words
Challenge No. 139: List those sentences which contain any pair of words where first word ends with vowel and next word starts with vowel.
Solved using: Power Query.
Top Initial Letters Count
Challenge No. 138: Find the top 5 highest occurring starting alphabets of words in US Presidents columns.
Solved using: Python in Excel.
Split and Pivot Data
Challenge No. 34: Split and pivot the Orders table
For example, Fred has only 2 Orders on the 14th and 15th Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Unique Letters Per Word
Challenge No. 137: List those strings whose words contain only unique letters.
Solved using: Power Query (Table.AddColumn).
Merge! Part 1
Challenge No. 114: In Question Table 1, the dates and product IDs are provided.
Solved using:Excel (FILTER, HSTACK, IFERROR), Google Sheets, Power Query (Text.Split, Table.AddColumn), Python, Python in Excel, R, and SQL.