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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation list using filtered range
Assume your named range is MyR
In Data Validation, Allow: List, use this as the Source: =OFFSET(MyR,COUNTA(MyR)-1,,-14) On Mar 2, 1:41*am, michaelberrier wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation list using filtered range
On Mar 1, 2:24*pm, Max wrote:
Assume your named range is MyR In Data Validation, Allow: List, use this as the Source: =OFFSET(MyR,COUNTA(MyR)-1,,-14) On Mar 2, 1:41*am, michaelberrier wrote: 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 Thanks for looking, but this formula just puts the text of the formula in the drop down box, not the actual filtered range. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation list using filtered range
Works for me.
How are you entering the formula into the List Source? I just used CTRL + C then CTRL + V Don't forget the "=" sign. Gord Dibben MS Excel MVP On Tue, 1 Mar 2011 15:30:58 -0800 (PST), michaelberrier wrote: On Mar 1, 2:24*pm, Max wrote: Assume your named range is MyR In Data Validation, Allow: List, use this as the Source: =OFFSET(MyR,COUNTA(MyR)-1,,-14) On Mar 2, 1:41*am, michaelberrier wrote: 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 Thanks for looking, but this formula just puts the text of the formula in the drop down box, not the actual filtered range. |
Reply |
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 |