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.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
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.
Create 2025 Broadcast Calendar
Challenge No. 695: Develop Broadcast Calendar for 2025.
Solved using: Python.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python 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.
Align Custom Data Layout
Challenge No. 686: This problem is contributed by RIJESH THOMAS
Align the data as shown.
Solved using: Python in Excel.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.