Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Detect Wavy Number Pattern
Challenge No. 474: Wavy numbers – List the numbers where digits alternately get smaller or larger (they should not be equal).
Solved using: Excel VBA.
Create a Detailed Table
Challenge No. 65: Create the Detailed table from the Summary
e.
Solved using: Python.
Pivot Yes No Percentages
Challenge No. 205: From tables T1 and T2, generate the result table.
Solved using: Python in Excel.
Evaluate Concatenated Math Rows
Challenge No. 472: All rows carry one mathematical operator (to simplify only 4 basic maths operators which are +, -, * and / ).
Solved using: Python in Excel.
Decrypt Keyword Cipher Text
Challenge No. 471: Decrypt the Encrypted Text using Keyword Cipher.
Solved using: Python in Excel.
Count Column Cross Matches
Challenge No. 204: For a column, find how many members of the column are contained in other columns.
Solved using: Python.
Next Larger Permutation
Challenge No. 470: Find the next number which is greater and made from arranging digits from that number.
Solved using: Python in Excel.
Sort Rows by Reference Column
Challenge No. 468: This challenge was posed by Sunny Baggu
List the rows from problem table as per column H.
Solved using: Python in Excel.
Average Between Blank Groups
Challenge No. 203: Prepare the groups which lie between two blank Amount1s and give the average of numbers appearing in those groups (groups shaded in light red).
Solved using: R.