data validation problem

[mukeshbaviskar]

In my file I have inserted data validation for surname as a warning message. When the surname is same then the message should display as a warning 'Duplicate entry' and show message 'Check first name'. I don't want to restrict the entry but only I want to warn the user that the same surname is already enter, then the user will check the first name and if it's same he will cansel the entry otherwise he if the first name is different then he will enter the details.
Please check and solve my problem.

Thank you.

Mukesh

[Ace_XL]

In data validation -- custom use

=COUNTIF($B$2:B2,B2)>1

[mukeshbaviskar]

Hello Ace_XL,
Thank you for correction. It's working fine.

Thank you.

Mukesh

[mukeshbaviskar]

Sorry! I have one problem that the validation should show the message when the entry is duplicate only and not for all entries. This formula restricts all the entries whether it is duplicate or not. Solution please.
File attached.

Mukesh

[Kevin UK]

Look into the Input Message & Error Alert when you are in the Data Validation dialogue box.

[mukeshbaviskar]

Ok! Now my problem is solved. I used the following formula:

=COUNTIF($C$6:$C$2000,C6)=1

Thank you.

Mukesh