Double data validation

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
I've tested this double validation formula below but I have a feeling I'm missing something. It works, but I'm wondering if anyone has a better solution.

It allows from a list, C1:C10 and prevents duplicates.

=AND(MATCH(A1,$C$1:$C$10,0),COUNTIF($A$1:$A$10,A1)=1)

TIA

:confused:
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,114,281
Messages
5,546,954
Members
410,764
Latest member
Dedeke
Top