Duplicate Entries

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

If I have a group of numbers in range A1:A25 and I want
to restrict duplicate entries, how should this be
handled, with data validation or conditional formatting?
Also, how exactly should this be done? Thank you
 
You could use validation. Select A1:A25 and go to Data >
Validation > Allow:Custom and insert:

=COUNTIF($A$1:$A$25,$A1)=1

HTH
Jason
Atlanta, GA
 
Back
Top