I was wondering if criteria can be added to the data validation list source.
For Ex:
I have a named range (called Days) for 365 days (A1 thru A365).
I have a bunch of cells that refer to that range. Obviously when I click on the dropdown arrow the list is quite long. Most of these cells don't need to refer to the entire year. Can I add a Min and Max statement in the Data Validation Source box.
For Ex:
I have a named range (called Days) for 365 days (A1 thru A365).
I have a bunch of cells that refer to that range. Obviously when I click on the dropdown arrow the list is quite long. Most of these cells don't need to refer to the entire year. Can I add a Min and Max statement in the Data Validation Source box.