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:
