Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
Draw Boat Using Grid
Challenge No. 435: Draw the given boat..
Solved using: Excel VBA.
Quarterly Hike Compounding Table
Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.
Find Missing Pythagorean Quadruple
Challenge No. 429: A Pythagorean quadruple is a set of 4 integers a, b, c, d such that d^2 = a^2+b^2+c^2.
Solved using: Python in Excel.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.
Transform Input to Result Table
Challenge No. 181: Generate the result table from problem table.
Solved using: Python.
Evaluate Tic Tac Toe Results
Challenge No. 426: Find the results of given Tic Tac Toe (Noughts and Crosses) boards.
Solved using: Python.
Max Monthly Sales Change
Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.