|
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. |
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. . |
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. . |
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. . |
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. . |
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. . |
| All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com