I got through a few interesting formula challenges in the Round 2 of Excel World Champ. One of the formula based question was similar to this Excel Challenge

Let’s see if we can knock this down!


Here is the Data

Seven students and their marks in 5 subjects. This data is converted into a table named ‘Marks’


Your Challenge : Find the lowest scoring subject for students ? (Quick Edit) : Find the subject that got the lowest marks for any student ?

I mistakenly wrote lowest scoring subject for students. I have also updated the excel file


Just one Rule : Use a single formula to get the name of the subject!




Post your answers in the comments!


Our Past Excel Challenges

  1. Separate the values in Columns
  2. Find the Shift Timing Challenge
  3. Solve this question without IF (or any other logical function)
  4. Make a Chart from this Data – Charting Challenge
  5. Find the Total Hours – Excel Challenge


Topics that I write about...

Download Smart Ebooks on
Excel and Power BI