Help with formula for returning heading of lowest 3

[jdkay]

I'm sure I saw a way to do this, but now I can't find it. I needed a way to find the lowest grade in a subset of grades. The learning management system couldn't help me. I found directions on here and youtube that allowed me to highlight the lowest grade. that served my purpose. But, now I want to return the lowest 3, and I might as well use the power of excel to get the headings which is what I truly need.

I have attached the workbook. The first sheet is the raw quiz grades and the # of possible points. The following sheets are all me learning how to highlight in the array. The tabs are labeled such that it should be obvious what I am doing. On the aggregate tab the column labeled min is me manually typing in the # of the quiz on which the student had the lowest percentage grade. Ideally, it would self populate and so would next lowest and so on.

Again, I'm pretty sure I had seen directions to do this for 1 grade, and now I can't even find that. Wrong search terms, I guess.

Thanks in advance for any and all advice.

John

[FDibbins]

Hi and welcome to the forum

Doesnt look like the workbook attached?
to get the lowest 3, use
=SMALL(range,1)
=SMALL(range,2)
=SMALL(range,3)

[jdkay]

oops sorry I did forget the attachment. Not sure if the small will work because it was essentially an array. I'll give a look see. But, here is the workbookreview quiz grades.xlsx


Look see results: it works, but I would like to retrieve the column header.

Thanks

John

PS I'm working in the aggregate tab.

[FDibbins]

Not sure if this is something you can work with? I have pulled out the lowest 3 values in the table, and then used Conditional Formatting, based on those values, to highlight the cell/s that match those3 values (excluding zero)

[jdkay]

Thank you. I don't see your work in the file. BUT, there was a link at the bottom to similar questions. Using your previous help and that link [used index and match] I have it. It's not elegant, but it works like a charm. Next time I'll figure out how to do it one step [small, index, match] rather than 2. But I'm ready for the students tomorrow.

Thank you again.

Next question. How do I mark this solved? I don't see it. It's right in front of me isn't it?