Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.
Generate Triangles By Row Count
Challenge No. 448: Given the r (number of rows) value in column A, generate the given triangles.
Solved using: Python.
Find Penholodigital Squares
Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.
Schedule and Cost Performance
Challenge No. 192: Convert the problem table into result table.
Solved using: Python.
Top 3 Closest City Pairs
Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.
Extract Valid Structured Words
Challenge No. 191: Extract the words which are either numbers followed by all uppercase English letters or vice versa.
Solved using: Python in Excel.
Generate Look-and-Say Sequence
Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.
Delete Duplicate Rows
Challenge No. 58: Delete rows with duplicate Invoice, User & Dept, whose values can be completely Offset.
Solved using: Python.
Find Birds in Grid Rows
Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.