Forum Discussion
Finding bottom 10 values with criteria
Hi all, I'm currently currently trying to pull the bottom 5 values from a table based off of criteria. The criteria is a ID # ex. "1056" and the other data I want to rank is distance. To do this I f...
Are your IDs numbers or text? If they are numbers, omit the quotes around the value:
=IFERROR(SMALL(IF(A2:A20=1056,C2:C20,""),ROW(1:5)),"")