Use array formula:
In I2:
=IF(LARGE($N$2:$N$27-ROW($N$2:$N$27)*10^-10,H2)<0,"",INDEX($M$2:$M$27,MATCH(LARGE($N$2:$N$27-ROW($N$2:$N$27)*10^-10,H2),$N$2:$N$27-ROW($N$2:$N$27)*10^-10,0)))
In J2:
=IF(LARGE($O$2:$O$27-ROW($O$2:$O$27)*10^-10,H2)<0,"",INDEX($M$2:$M$27,MATCH(LARGE($O$2:$O$27-ROW($O$2:$O$27)*10^-10,H2),$O$2:$O$27-ROW($O$2:$O$27)*10^-10,0)))
In K2:
=IF(LARGE($P$2:$P$27-ROW($P$2:$P$27)*10^-10,H2)<0,"",INDEX($M$2:$M$27,MATCH(LARGE($P$2:$P$27-ROW($P$2:$P$27)*10^-10,H2),$P$2:$P$27-ROW($P$2:$P$27)*10^-10,0)))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Drag down
Bookmarks