Show a message if there are some duplicates

[jean]

Hi

I have a worksheet with 4 columns as the first one should contain only
unique value I use conditional formatting to highlight duplicates.
I also use for that column Data Validation as I want to restric the
user to a certain format.

Now I would like a formula in a cell that would do this

"If there are some duplicate in column A4:A300 "You have some
duplicate, please correct them" unless no mesage
a bit like = if (****** = True, "Please correct", "")

I repeat Data Validation is already used for another purpose

Thanks for helping

 

[Jim Cone]

In case you weren't aware, it is usually best to acknowledge responses to a question before asking
another one.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Greatest Film List.xls - in the free folder)




"jean" <[email protected]>
wrote in message
news:a965d150-d594-42aa-9f94-1e6e8b00a93d@h12g2000yqg.googlegroups.com...