Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation list using filtered range
I have a sheet that populates a data validation in-cell drop down with
a named range of dates. This list of dates is quite long and historical, but I only need to be able to see the last 14 days in the drop down list. How can I set it up to filter this range in the drop down? Thanks, mb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtered Validation List | Excel Worksheet Functions | |||
Using a filtered list as data range for a chart | Charts and Charting in Excel | |||
Using a filtered list as data range for a chart | New Users to Excel | |||
Charts: using a filtered list as a data range | New Users to Excel | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions |