Challenge No. 687: Fill in the blank with max of (max of remaining cells of row going to right and max of remaining cells of column going down).
Solved using: Python in Excel.
MAX
Returns the largest value in a range in Excel.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Identify Missing Number Ranges
Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.
Transpose table, compute gross profit
Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
Find Smallest Uncreatable Sum
Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Digit Sum in Fibonacci Sequence
Challenge No. 580: Let’s code golf.
Solved using: Python.
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.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.