Change the sort order of the filter
 

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?

Change the sort order of the filter
 

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

Tyro

"AllYourSpam" wrote in message
...
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?

Change the sort order of the filter
 

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?

"Tyro" wrote:

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

Tyro

"AllYourSpam" wrote in message
...
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?

Change the sort order of the filter
 

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

"AllYourSpam" wrote:

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?

"Tyro" wrote:

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

Tyro

"AllYourSpam" wrote in message
...
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?

Change the sort order of the filter
 

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

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