LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mrpb
 
Posts: n/a
Default Autofilter on date fields should refelct the underlying data (rat.

I have a sheet with a list of dates formatted "ddd dd mm yy". It would be
useful to be able to jump to a particular date using autofilter, but the drop
down box offers the various dates in an order determined by the formatted
version of the date (all Fridays, then Mondays, Saturdays, Sundays,
Thursdays, Tuesdays and Wednesdays). It would be more helpful if the drop
down box looked at the underlying date data and ordered the alternatives
accordingly.
 
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
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 4 December 1st 04 06:47 PM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 1 December 1st 04 05:55 AM
Formatting date fields after export Raymond Excel Discussion (Misc queries) 2 December 1st 04 12:04 AM


All times are GMT +1. The time now is 04:54 AM.

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"