Sorting Data

  • Thread starter Thread starter Curtis Stevens
  • Start date Start date
C

Curtis Stevens

A1 = Street number like 1234
B1 = Street name like lake wood drive

I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

Thanks!
Curtis
 
Just to add to smartin's post, you *can* sort with blank Rows or Columns
*provided* you select the area to be sorted first. Blank rows will be
sorted to the bottom of the list. It is also good to ensure that "My list
has Headers" is selected if you have headers.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Sorting Prospects by street name 1
Replacing a formula with the actual string or number 1
Word Create a Phone Book using MailMerge in word 2007 0
Sorting by Content 5
In search of a new Obelisk 6
Find duplicates in address register 2
SORTING BY ODD OR EVEN NUMBERS 1
How do I insert page breaks in a huge EXCEL file? 4

Back
Top