In the below data, only the ones highlighted in Red are duplicates whereas the Green ones aren't duplicate as their statuses are different.
I want a code to check if there are any duplicates in the sheet. If duplicates exist then it should give a message box stating "please remove the duplicates".
The columns to be checked for duplicates are Column C & column F in combination (not individually).
The below data is just a sample.
Also cross posted in
https://www.mrexcel.com/board/threads/vba-msgbox-if-duplicate-exists.1127478/
I want a code to check if there are any duplicates in the sheet. If duplicates exist then it should give a message box stating "please remove the duplicates".
The columns to be checked for duplicates are Column C & column F in combination (not individually).
The below data is just a sample.
Names | Product Status |
Alan | Returned |
Barbara | Returned |
Charlie | Sold |
Dave | Sold |
Alan | Sold |
Huzbert | Sold |
Barbara | Sold |
Inez | Sold |
Mark | Sold |
Barbara | Sold |
Norah | Sold |
Also cross posted in
https://www.mrexcel.com/board/threads/vba-msgbox-if-duplicate-exists.1127478/