Autofilter Question

[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

 

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