--In the next available column say J. Enter the query date in cell J1

--In J2 enter the below formula and copy/drag down
=IF(COUNTIF(B2:I2,$J$1),"Found","")

--Now filter by that column

If this post helps click Yes
---------------
Jacob Skaria


"crazidazi3" wrote:

I can't find my org post, so reposting..sorry.

I have a worksheet that has multiple columns, with multiple dates..

Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5
1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09
2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09
3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09
5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09

I need to filter for all acct #s with a follow up date of 10/24/09 (or
whatever date I need). I have tried all versions of advanced filter, but it
does not allow you to search by multiople date across columns. Please help!
--
crazidazi3