Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Swap Grid Diagonals
Challenge No. 701: Swap the diagonals in 10×10 grid as shown.
Solved using: Python 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.
Evaluate Pass Based on Subjects
Challenge No. 696: Document Pass or Fail against all students.
Solved using: Python in Excel.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
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.
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.