Wednesday, June 15, 2011

yogi_Sort Street Addresses In Ascending Order

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
Stever17 said:
Sorting Street Address working strangely
I am using Google Docs Spreadsheet. There are addresses within a column. When I sort, they are sorted in the order below, i.e. first all the addresses starting with "1", then all the addresses starting with "2", etc. Is there a way to make it sort from smallest to largest house number within the street address?
1 APPI
100 RAMONA
101 GREEN
1021 MARSH
1022 10TH
1028 SAN
104 E ST
106 CLAY
106 SANTA
1061 BEACH
107 Livorn
1083 SUNNY
1107 MISSION
111 ROSA
1114 Lord
1135 TOURNAMENT
1148 FERNANDEZ
1168 HILLSIDE
12 CANYON
121 CLAY
1216 S NORFOLK
1227 Carlton
1241 CRESTWOOD
1241 S MAYFAIR
--------------------------------------------------------------
In Sheet1 street addresses are sorted in ascending order by property number and in ascending order by street address 


update:
I have added Sheet1a where street addresses are sorted in descending order by property number and in ascending order by street address