Challenge No. 563: List the products, range of numbers along with the count of bands (not count of product).
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Palindrome One-Child Numbers
Challenge No. 562: One Child Palindromes – Find all unique substrings of a number excluding 0 and if one and only one substring is divisible by the length of the number, then this is called One Child number.
Solved using: Python.
Generate the result table from
Challenge No. 256: Generate the result table from problem tables.
Solved using: R.
Maximum Profit from Transactions
Challenge No. 561: For each row, you need to buy first and sell second.
Solved using: Python in Excel.
Progressive Column Max Finder
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.
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.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.