Filters
 

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.

Filters
 

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.



Clint Eastwood wrote:

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.

--

Dave Peterson

Filters
 

Thanks Dave. Don't think I needed the "0" though.
Clint

"Dave Peterson" wrote:

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.



Clint Eastwood wrote:

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.

--

Dave Peterson

Filters
 

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.

Clint Eastwood wrote:

Thanks Dave. Don't think I needed the "0" though.
Clint

"Dave Peterson" wrote:

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.



Clint Eastwood wrote:

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.

--

Dave Peterson


--

Dave Peterson