View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAW GAW is offline
external usenet poster
 
Posts: 4
Default how to sort addresses in microsoft excel

I have 2 lists of addresses on one sheet. Most of the addresses are
duplicates and I want to sort them so it puts all the duplicates together.
The streets include the house number, as 1257 Rock St. I can sort them by
street alone but I need to sort by street and the address together, is there
a way to do this? I am using Excel 2000, 9.0.2720.