sorting in excel

  • Thread starter Thread starter elsa
  • Start date Start date
E

elsa

how do i sort addresses in excel. i have saved the addresses in thre
rows. for example




*_address_______|______details_______________ *
----------------|----------------------
aaaaa | fdskfh sdkjsfk
aaaaa | hsdjahdjk
aaaaa |
---------------------------------------
|
bbbbb | hjjkhuhjkhlkj
bbbbb | hkjhjjjhjkk
bbbbb |

where a and b are two different addresse
 
Hi

I'm afraid you have to redesign your sheet - unless you'll write a VBA
script which does sorting.
My advice is to use design:
Address, Detail1, Detail2, ...
i.e. a row for every address.
 
Looks like they're sorted to me... All aaaaa first then bbbbb next ...
Could you clarify your question? You may select Data|Sort from the menu and
select first sort order as address then secondly by details....
 
Back
Top