How Excel can tell me i have entered a duplicate number

D

Dav

Well one way is to go to conditional formating and choose formula and in
cell A1 put =countif(a:A,a1)>1 and format to turn the cells red

this will highlight duplicates in red

Regards

Dav
 
G

Guest

Autofill said:
how do i get excel to tell me
i have entered a duplicate number in a specific column
Click to expand...

Another play is to use Data Validation

Select col A
Click Data > Validation
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Click OK

Test it out ..

---
 

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

Identifying duplicate data 4
Red cell for negative numbers in Excel 1
How can I count dates if few duplicates in a column 3
Duplicates Deletion ? 2
duplicate numbers 1
Formula for checking duplicate numbers 3
unique number 2
Do not duplicate number 3

Top