Challenge No. 703: Today’s challenge is contributed by Duy Tùng
It is required to calculate the total for each employee over consecutive (or separate) days and take the maximum value.
Solved using: Python.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Evaluate Student Subject Status
Challenge No. 697: Document Pass or Fail against all students.
Solved using: Python in Excel.
Evaluate Pass Based on Subjects
Challenge No. 696: 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.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
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.
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.
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.