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