| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the sort order of the filter
Thanks, I'll give it a try.
"Debra Dalgleish" wrote: You can't change the filter dropdown, but you could add a column to the table, and calculate the difference in years. For example, with years in column A: =TEXT(YEAR(TODAY())-A2,"000") & " - " &A2 Then, filter on the new column, and the most recent years will be at the top. AllYourSpam wrote: Working in 07, I have a column of years that ranges back over 100 years that is filtered. Is there a way to have the FILTER show in reverse order? Doesn't matter if I sort the colunm A-Z or Z-A, the filter always shows oldest year first and we mostly work with the more recent so we have to scroll to the bottom of a very long filter almost every time. Can that be changed? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| How to change the column order in Excel table with multiple sort | Excel Discussion (Misc queries) | |||
| Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
| sort order | Excel Discussion (Misc queries) | |||
Hybrid Mode
