Duplicate Entries

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
 
J

Jason Morin

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

Duplicate entry in a column/row 14
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Recover Outlook calendar entry 1
using duplicate function 19
Delete all data after a symbol in a field 0
get Data Validation to stop, list supplied, duplicate data entries 1
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Identify duplicates in row with conditional formatting 7

Top