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.
Regex Password and Vowel Checks
Challenge No. 557: Another series of 3 challenges into one to hone your regex skills.
Solved using: Python in Excel.
Transpose the data given in
Challenge No. 253: Transpose the data given in problem table to hierarchal data in result table.
Solved using: Python 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.
Identify Kaprekar Numbers
Challenge No. 554: Kaprekar Number = Take an n digit number, square it, divide it into 2 parts such that part1 + part 2 = n where part1 or part2 should not be 0, then it is a Kaprekar number.
Solved using: Excel VBA.
Draw ASCII Abacus Display
Challenge No. 553: Draw an ASCII abacus.
Solved using: Python in Excel.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Three Regex Pattern Tasks
Challenge No. 552: This time 3 challenges into one to hone your regex skills.
Solved using: Python in Excel.