Listing top three names which have the most blank values


I have two classes (ABC and XYZ) and some students which have taken test in these classes. However, due to personal reason, a few students couldn’t take several of the exams. I want to find the top 3 amounts of test not taken and top 3 names of the students that haven’t taken the most exams. Below is an illustration of what I’m trying to do:

In cell F3, I’ve written the following code to get the top 3 amount of test not taken:


My goal is to now list the top 3 non test taker names. I’ve tried a variation of the above code but can’t seem to make it work. I have excel version 2209 if this helps. Thank you in advanced!

>Solution :


Formula in E2:


Or, for both names and count:


Leave a Reply Cancel reply