Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Sequential Counter For IDs
Challenge No. 689: This challenge is contributed by Duy Tùng
The task is to assign sequential numbers to the Result column based on the Number column.
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.
Align Custom Data Layout
Challenge No. 686: This problem is contributed by RIJESH THOMAS
Align the data as shown.
Solved using: Python in Excel.
Detect Overlapping Tasks
Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
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.