Change the sort order of the filter

[Guest]

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?

 

[Tyro]

I apply a filter to the dates. Then I sort the filtered list as newest to
oldest. Works fine.

Tyro

 

[Guest]

Unless I misunderstood, that doesn't change the drop-down of the filter, my
filter still reads in order 1865 - 2008. I want, when I click on the filter
arrow box, to show me the check box "Select All", 2008 then 2007, etc., not
1865, 1866 ...

Does that make sense?

 

[Sean Timmons]

Oops, I responded to the wrong person on this one.

I do not believe that can be done. I would suggest using a Pivot Table so you
can parse out the data you need, then you can click in the date field, go to
Data - sort, and click descending...

Not sure how you feel about using Pivot tables...

 

[Debra Dalgleish]

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.

 

[Guest]

Thanks, I'll give it a try.

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.