Challenge No. 46: List the Teams and the number of matches won by them.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Same Initial Letter Names
Challenge No. 45: Provide a formula to list the names where all words start with same alphabet.
Solved using: Power Query (Table.SelectRows).
List Candidates Matching Skills
Challenge No. 43: A1:C9: List of candidates with their primary and secondary skills.
Solved using: DAX.
Fill Missing Sequences Per ID
Challenge No. 12: (Excel formulas also welcome)
If there is a sequence missing for a given ID, fill in the missing sequence and repeat the row above for all other columns.
Solved using: Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group).
Find Common Letters Between Words
Challenge No. 40: Provide a formula to find common unique alphabets between 2 cells in same row.
Solved using: Power Query.
Toggle Alphabet Case
Challenge No. 36: Provide a formula to reverse the case of English alphabets.
Solved using: Power Query.
Generate Pascal’s Triangle
Challenge No. 35: Provide a formula to create the triangle shown.
Solved using: Power Query.
Price List!
Challenge No. 87: The question tables provide product price lists on various dates and transaction records.
Solved using:Excel (FILTER, LAMBDA, LOOKUP), Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Extract last group of digits from string
Challenge No. 34: Extract the last group of numbers from a given string.
Solved using: Python in Excel.
Generate A to Z letter sequence
Challenge No. 33: Provide a formula to generate the sequence shown (A till Z only).
Solved using: Power Query (List.Transform).