|
|
|
|
#1
11-17-2023, 11:27 PM
|
||||
|
||||
This reference's method works for me
Excel formula: Data validation unique values only Allow = Custom Make sure you are ignoring blanks Try <2 instead of =1
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Data validation the other way round?
|
Officer_Bierschnitt | Excel | 3 | 11-13-2015 10:12 PM |
|
data validation from another sheet
|
paulys | Excel | 1 | 06-30-2014 01:40 AM |
|
Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
Windows 10 
Office 2016
Hybrid Mode