Isnt a problem a result of the second header row you have in your worksheet?
If you delete it it shall be solved for the first few entries.
But then I noticed you have a separate group below. So, forget about just deleting. Let's make a bold change - for instance in G11 array formula:
as you see we are using ROW(1:1) - it returns 1 in this line, but as we copy down 2,3, etc, so you have smallest, second smallest etc.![]()
=SMALL(IF(ISNA($E$11:$E$14),TRUE,$E$11:$E$14),ROW(1:1))
Bookmarks