Filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 columns of dates ( MM/DD/YYYY) from 2000 to say 2010. How do you
display ( filter) only the year 2000 ?? 2007 ?? etc.
Thanks,
Clint E.
 
If you're only filtering by a single column, you could use Custom and then
filter to show all the dates greater than or equal to January 1, 2000 AND less
than or equal to December 31, 2000.

If you wanted to see the rows where any of the fields was in 2000, then you
could insert a new column and fill it with a formula that looks like:

=((year(a2)=2000)+(year(b2)=2000)+(year(c2)=2000))>0

This will return a true (if any of the years were in 2000) or false (if all the
years were not in 2000).

Then drag the formula down the rows you need and filter to show the True's.
 
If you want to filter by true/false, you'd want the >0.

If you were going to filter by 0 or non-zero, you wouldn't need it.
 
Back
Top