sorting in excel

[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

 

[Arvi Laanemets]

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.

 

[doco]

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....