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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using duplicate function 13
Access Auto Matching Duplicates? 0
Duplicate Entries 1
Remove Rows That Are NOT Duplicates 4
Identify duplicates in row with conditional formatting 7
Data Validation, Identify Duplicates and Limit imput 7
How to generate random numbers from a range of cells? 3
COUNTIF 15

Back
Top