Challenge No. 4: Generate the result table as shown.
Solved using: Power Query.
Find Common Animals
Challenge No. 13: Provide a formula to generate the list of animals who are common in all 3 columns.
Solved using: Python in Excel.
Second Words Start with C
Challenge No. 12: List the words where second word starts with C.
Solved using: Python in Excel.
Caesar Cipher for Digits
Challenge No. 11: Cryptography Challenge – Caesar’s Cipher
Shift the each digit by values given in column B.
Solved using: Python in Excel.
Total Distance!
Challenge No. 81: The distance between cities and staff travels are provided in the question distance and travel tables.
Solved using:Excel (DROP, IFNA, INDEX), Power Query (Table.AddColumn), Python, and R.
List Names with Two Words
Challenge No. 10: Provide a formula to list all names in A2:A20 which has two words only.
Solved using: Python in Excel.
Generate result table from Alphabets
Challenge No. 3: (Excel formulas also welcome)
Generate the result table from Alphabets table.
Solved using: Power Query (List.Distinct).
Case-Sensitive Revenue Lookup
Challenge No. 9: Provide the Excel formula to get Revenue in cell E3 for a company given in cell E2.
Solved using: Python in Excel.
Bottom-Up VLOOKUP Formula
Challenge No. 8: Provide a formula in E3 to perform VLOOKUP from bottom for city given in E2.
Solved using: Python in Excel.
Count Letters and Digits
Challenge No. 7: Provide a formula to count the number of English alphabets and numeric digits in every cell.
Solved using: Python in Excel.