Advance Filter

**tt388** · 11-27-2008, 03:09 AM

Question about criteria for Advance Filter.

Can I add a criteria which is pointing to a cell?

For example, the Criteria I want is >A1 , where A1 is a date.

**Freaky_zoid** · 11-27-2008, 03:45 AM

tt388, you can use an autofilter, then select "Custom..." in drop-down menu and enter your criteria - "is greater than" in the left box and your date in the right

Does this help?

**tt388** · 11-27-2008, 03:58 AM

Freaky_zoid,

I have multiple AND / OR criteria that I have to use Advance Filter....

**Freaky_zoid** · 11-28-2008, 04:07 AM

tt388, please give more information about the data you are working with, criteria, and desired results.

**romperstomper** · 11-28-2008, 04:18 AM

You should be able to use:
=">="&A1
in your criteria cell.

**rwgrietveld** · 11-28-2008, 04:41 AM

romperstomper,

Yes you can. It's a bit hard to explain so I've added a WS.

It looks like this: =C7>$C$2. For you the C7 would be the first cell of your table and C2 would be A1.

Just play with it and you'll be able to see what I mean.