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

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