Challenge No. 559: For all columns, find the max in a cell considering its range from 1st cell till that cell.
Solved using: Excel VBA.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Build Cumulative Triangle Grid
Challenge No. 556: Generate this triangle where bottom row starts with 1 and all rows contain numbers which are cumulative sum from 1 to A1.
Solved using: Python in Excel.
Sort Alternate Row Patterns
Challenge No. 555: Sort odd numbered rows into ascending order, even numbered rows into descending order and populate their corresponding cities in the result.
Solved using: Python.
Prepare the result table from
Challenge No. 252: Prepare the result table from problem table.
Solved using: Python.
Draw ASCII Abacus Display
Challenge No. 553: Draw an ASCII abacus.
Solved using: Python in Excel.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
First and Last Number Sum
Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.