Selection query

K

KiwiBrian

In a column of a couple of thousand addresses, I want to copy to a new
spreadsheet all of the entries (in that column only) that fullfill the
criteria of 'nnn Short St" where nnn is any number from 1 to 9,999.
I also want to sort them by number, should that be a seperate subsequent
process on the new list of entries?

Thanks for any pointers.
Brian Tozer
 
G

Gord Dibben

Brian

Data>Filter>Autofilter. Custom>Less than or equal to 9999.

Copy to a new worksheet.

You could sort on number first or after the above.

Gord Dibben Excel MVP
 
Top