alphabetical listing reqd

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Hi

I had the following information headers in an excel file:

Name Address Address2 City

containing around 200 records.

What i want is to sort the list alphabetically, so that the result should
look like:

A
record1
record1
record1
record1

B
record1
record1
record1

C
record1
record1


and so forth..


please suggest.

Deepak
 
Perhaps the easiest way is to make 2 extra entries for each letter. The
first entry for 'A' would be 'A' and the letter colour (color) should
be set to the same as the background (this would most likely be white).
The second entry would be 'A." so it will come after 'A' in a sort.
Resort your data and there you have it.

If you don't like the idea of 'fake' data in you list then you could
create a 'Subtotal' column a few columns to the right of your data with
the formula =LEFT(A1,1) to get the first letter. Subtotal this and it
will split you list but subtotal isn't really designed for this and it
won't give you the letter heading.

Another option is VBA. This might not be too smart a move if you're not
familliar with VBA. Repost if you do want to use VBA for this.

Cheers
 
Back
Top