Autofilter Question
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 |
Autofilter Question
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 |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com