Challenge No. 40: Provide a formula to find common unique alphabets between 2 cells in same row.
Solved using: Power Query.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
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.
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).
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.
Dynamic Result Table Generation
Challenge No. 10: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (Table.AddColumn, Table.SelectRows, Table.Sort).
Validate ISBN-10 Numbers
Challenge No. 29: List all books from A2:A10 which have a valid ISBN-10 number.
Solved using: Python in Excel.
Custom Ranking!
Challenge No. 85: In the Question Table, values are provided and we want to rank them in ascending order based on custom logic.
Solved using:Excel (FILTER, HSTACK, IF), Power Query (List.Sort, List.Transform), Python, and R.
Apply Caesar Cipher with Shift
Challenge No. 26: Caesar’s Cipher – This is second challenge on Caesar’s cipher.
Solved using: Power Query.