Autofilter Question

[k9nny]

Hello everybody,

I have an autofilter question. Instead of using a value, can I use a formula when specifying which rows to display, i.e. show rows where cell value is equal to today's date, or where cell is equal to another cell reference?

Thanks, Kenny.

[Dave Peterson]

Not in the filter dialog.

But you could insert a helper column of cells and put your criteria in that.

Then filter that range to show just the trues or falses.

k9nny wrote:
>
> Hello everybody,
>
> I have an autofilter question. Instead of using a value, can I use a
> formula when specifying which rows to display, i.e. show rows where
> cell value is equal to today's date, or where cell is equal to another
> cell reference?
>
> Thanks, Kenny.
>
> --
> k9nny
> ------------------------------------------------------------------------
> k9nny's Profile: http://www.excelforum.com/member.php...o&userid=20048
> View this thread: http://www.excelforum.com/showthread...hreadid=517455

--

Dave Peterson