Adding Criteria To Data Validation List Source

gerryger

Board Regular
Joined
Apr 19, 2010
Messages
54
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.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,108,574
Messages
5,523,677
Members
409,531
Latest member
wo1f

This Week's Hot Topics

Top