Challenge No. 12: List the words where second word starts with C.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
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.
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.
Find Max Points by Rounds
Challenge No. 5: Provide a formula to know the name of the persons who have the highest Points on the basis of Round1+Round2+Round3.
Solved using: Python in Excel.
Table Transformation! Part 5
Challenge No. 39: From the products list in the question table, extract the unique list of all product codes.
Solved using:Excel (SORT, TOCOL, UNIQUE), Power Query (List.Distinct, Table.Distinct, Table.Sort), Python, and R.