Challenge No. 701: Swap the diagonals in 10×10 grid as shown.
Solved using: Python in Excel.
INDEX
Returns a value or reference from a table based on row and column numbers in Excel.
Fill Missing Monthly Values
Challenge No. 698: Populate all months of the year.
Solved using: Python.
Evaluate Student Subject Status
Challenge No. 697: Document Pass or Fail against all students.
Solved using: Python in Excel.
Custom Sequence from Four Terms
Challenge No. 693: Generate a sequence taking first 4 numbers as 1, 2, 3, 4.
Solved using: Python.
Fill Cell With Max Right-Down
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.
Grid Lookup By Pattern
Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
Split And Sum Orders
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.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Sum Numbers in Zigzag Path
Challenge No. 623: Find the sum of numbers traversing the diagonal from first column to second column to third column to second column to first column and repeating it till the end.
Solved using: R.