Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Sequential Group Numbering Logic
Challenge No. 596: This challenge is contributed by Ankur Sharma
Populate 1, 2, 3.
Solved using: Python.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Repeat Vowels by Position
Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.
Animal Park Presence Matrix
Challenge No. 586: List all animals and all parks.
Solved using: Python.
Number Groups for Letter A
Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.