or this:Formula:
=IFERROR(SMALL(E$1:E$10;COUNTIF(E$1:E$10;0)+A1);"")
Formula:
=IF(LARGE(E$1:E$10;A1)>0;LARGE(E$1:E$10;A1);"")
or this:Formula:
=IFERROR(SMALL(E$1:E$10;COUNTIF(E$1:E$10;0)+A1);"")
Formula:
=IF(LARGE(E$1:E$10;A1)>0;LARGE(E$1:E$10;A1);"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks