Validation

hotstew44

New Member
Joined
Aug 19, 2004
Messages
21
i have a row from A1 to Q1 with data in each cell. i was wondering if i could validate this row so when the data is entered in each cell an error will occur if a duplicate entry is entered in this row.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,202
Office Version
  1. 365
Platform
  1. Windows
got it thanks!
In Data Validation, did you use something like this?
Allow: Custom|Formula: =COUNTIF($A$1:$Q$1,A1)=1
 

Watch MrExcel Video

Forum statistics

Threads
1,108,809
Messages
5,525,002
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top