Sorting rows by time-zone

[Matthew Dyer]

The spreadsheet has values in columns A-H, and the values for column E
are all states. I want to be able to do things like highlight the rows
based on time-zone, or be able to re-sort the data with eastern time-
zone states at top working to pacific time-zone accounts at the
bottom. the states are all abbreviated.

What do you think would be the easiest way of going about this? Any
ideas?

 

[joel]

1) I would build a table of states and timezones. the tines zones bein
a number -5 : Eastern Time Zone, -6 : Central Time Zone, -7 : Mountai
Time Zone, -8 : Pacific time zone. The number -5 to -8 are the standar
offset used for the timezones difference from Greenwich time (latitude
degrees).


A B
NY -5
IL -6
Ca -8




2) Then use an auxilary column with a vlookup to return the th
appropriate time zone for each row.

3) Replace the formula in new zuxilary column with values usin
pastespecial. theis is required so the sort will work properly

4) Sort on New auxilarry Column