Returning values from a table

Hi Everyone,

I have a table of distances from various cities in Europe and I want to find a way to return all cities from, for example Madrid, that are less than 500 km away. I'm sure there is a basic way to do this. Any help would be appreciated!
Table posted below
Thanks!

Originally Posted by Rabino1308

Hi Everyone,

I have a table of distances from various cities in Europe and I want to find a way to return all cities from, for example Madrid, that are less than 500 km away. I'm sure there is a basic way to do this. Any help would be appreciated!
Table posted below
Thanks!

I highly recommend creating a pivot table from you data set which allows you to filter specific cities as well at a specific distance such as 500km