|
|
#3
11-17-2023, 11:16 PM
|
|||
|
|||
Thank you for the prompt response and help. I have used the following formula:
=COUNTIF($E$3:$E$20000,E3)=1 Thank you once again. 
|
|
|
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 11 
Office 2021
Threaded Mode