In the below data, only the ones highlighted in Orange are duplicates.
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.
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 |
Last edited: