Sorting rows by time-zone

M

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top