Thread: How Excel can tell me i have entered a duplicate number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How Excel can tell me i have entered a duplicate number
"Autofill" wrote:
how do i get excel to tell me
i have entered a duplicate number in a specific column

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote