| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entry must match value in range
I have a range of cells with dates like: 1/1; 1/15; 1/31; 2/1; 2/15; 2/28...
To the left of the range a user will enter a date. I want to make sure that the date matches a value in the range above. For example, 1/7 is invalid whereas 2/1 is fine. I'd prefer not to use a dropdown. This hasn't been easy for me to figure out and I'm hoping someone can help me instert the correct validate formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find closest text match for each unique entry in a list | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Highlight a range for data entry | Excel Discussion (Misc queries) | |||
| How do I set up Data entry to match My Application Form | Excel Discussion (Misc queries) | |||
| Allowing only one entry in a range | New Users to Excel | |||
Threaded Mode
