Selection query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Good at Macros? I'm Trying to find duplicate entries. 3
Select the first number/numbers in a cell input into another colum 5
Numeric sorting of addresses 5
query criteria 2
Spreadsheet column width from html 2
Totalling then Averaging subject to Product Code change 3
Multiple entries query 6
Autonumber based on year 6

Back
Top