Finding bottom 10 values with criteria

New Contributor

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 found this.


I've tried to use it but it just won't work returning the #NUM! error every time. Based off what I could find online I've narrowed it down to some sort of formatting issue but no matter how I try to format my data it wont work. Does anyone have any advice?

1 Reply


Are your IDs numbers or text? If they are numbers, omit the quotes around the value: