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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Extract Valid Year Ranges
Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.
Swap Grid Diagonals
Challenge No. 701: Swap the diagonals in 10×10 grid as shown.
Solved using: Python in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Remove One Letter Palindrome
Challenge No. 699: Only one alphabet can be removed from Words list and it should become a palindrome.
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.
Evaluate Pass Based on Subjects
Challenge No. 696: 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.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.