Show a message if there are some duplicates

  • Thread starter Thread starter jean
  • Start date Start date
J

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
 
Back
Top