LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 178
Default Sorting rows by time-zone

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert time from one zone to other zone in excel ram Excel Worksheet Functions 1 April 25th 07 01:24 PM
Time Zone.. Trevor M Excel Discussion (Misc queries) 1 April 10th 06 08:49 AM
time zone chart R.VENKATARAMAN Excel Worksheet Functions 1 December 11th 04 12:43 PM
Time zone using VBA ged Excel Programming 0 October 25th 04 05:29 PM
Time zone using VBA ged Excel Programming 1 October 20th 04 05:25 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"