software

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

--

Dave Peterson