Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Format them as "dd mm yy ddd".

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

  #3   Report Post  
mrpb
 
Posts: n/a
Default

Unfortunately, that then shows all the '01' days first, followed by the '02'
days etc.
Formatting as yyyymmdd ddd would work - but that rather destroys the point
of friendly formatting.

"Jason Morin" wrote:

Format them as "dd mm yy ddd".

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.


  #4   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Try EasyFilter
http://www.rondebruin.nl/easyfilter.htm

Next week I will release a new version (with a of Date filter options)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"mrpb" wrote in message ...
Unfortunately, that then shows all the '01' days first, followed by the '02'
days etc.
Formatting as yyyymmdd ddd would work - but that rather destroys the point
of friendly formatting.

"Jason Morin" wrote:

Format them as "dd mm yy ddd".

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.




  #5   Report Post  
Ron de Bruin
 
Posts: n/a
Default

This is correct : with a lot of Date filter options

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Try EasyFilter
http://www.rondebruin.nl/easyfilter.htm

Next week I will release a new version (with a of Date filter options)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"mrpb" wrote in message ...
Unfortunately, that then shows all the '01' days first, followed by the '02'
days etc.
Formatting as yyyymmdd ddd would work - but that rather destroys the point
of friendly formatting.

"Jason Morin" wrote:

Format them as "dd mm yy ddd".

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.








  #6   Report Post  
mrpb
 
Posts: n/a
Default

Thanks for your help.

"Ron de Bruin" wrote:

This is correct : with a lot of Date filter options

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Try EasyFilter
http://www.rondebruin.nl/easyfilter.htm

Next week I will release a new version (with a of Date filter options)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"mrpb" wrote in message ...
Unfortunately, that then shows all the '01' days first, followed by the '02'
days etc.
Formatting as yyyymmdd ddd would work - but that rather destroys the point
of friendly formatting.

"Jason Morin" wrote:

Format them as "dd mm yy ddd".

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.







Reply
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 06:15 PM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 4 December 1st 04 07:47 PM
Split combined date time data Mark Ada Excel Discussion (Misc queries) 1 December 1st 04 06:55 AM
Formatting date fields after export Raymond Excel Discussion (Misc queries) 2 December 1st 04 01:04 AM


All times are GMT +1. The time now is 06:26 AM.

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

About Us

"It's about Microsoft Excel"