In the past, I used to trace through a list of 500 orders one by one with my eyes to extract the 'unpaid orders from Sapporo' ...
I have a work sheet, it has 10,000 rows. 2,000 of those are for the state of New York. So I add a filter, then drop down on the state column and select New York. I then have 2,000 rows displayed. I ...