Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.
BYROW
Applies a function to each row in an array in Excel.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
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.
Find Missing AP Sequence
Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.
Match Words in Column Data
Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
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.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Odd Numbers in Matrix
Challenge No. 546: List the odd numbers reading rows from left to right and columns from top to bottom.
Solved using: Python.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Find Min Product of Three
Challenge No. 537: Find the minimum product which results from multiplying any 3 numbers from N1 to N6.
Solved using: Python in Excel.