Autofilter Question

K

k9nny

Hello everybody,

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

Thanks, Kenny
 
D

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.
 
Top