Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter with formula
I'd like to set an auto filter that will filter out any data with a date
greater than today. What I'm looking for is a way to set the auto-filter to: "Column data" is greater than =today() But I can't seem to get it to work.... Anyway to filter dates with an =today() formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter with formula
Using the auto-filter, select the Date field, then goto custom. A dialog box
will open and enter greater than and the date you require for the criteria. This should filter any data correctly as you require from the description below. "Brian" wrote: I'd like to set an auto filter that will filter out any data with a date greater than today. What I'm looking for is a way to set the auto-filter to: "Column data" is greater than =today() But I can't seem to get it to work.... Anyway to filter dates with an =today() formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use a formula to filter data? | Excel Worksheet Functions | |||
Filter formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
formula to find the filter criteria | Excel Worksheet Functions | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions |