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?

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


A B
NY -5
IL -6
Ca -8




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

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

4) Sort on New auxilarry Column.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150329

Microsoft Office Help