Find duplicated row values and show a message in order to take action.

[kanelones]

Hi guys.

This time need your help to find a way to search for duplicated rows within a certain range, but not just delete them with the "remove duplicates " menu option , but let the operator decide what to do, with an error message, could be a text "THERE IS DUPLICATED VALUES!" in a cell, or a popup message, etc.

Any help will be appreciate as usual.

Thank you in advance !

P

 

[AlphaFrog]

Would you rather just highlight any duplicates? You can do that with Conditional Formatting.

This link is a step-by-step guide.
Highlight Duplicates in Column

 

[kanelones]

Would you rather just highlight any duplicates? You can do that with Conditional Formatting.

This link is a step-by-step guide.
Highlight Duplicates in Column

Thanks, it go me some ideas to use..