• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA beginner : Msgbox if any duplicates exist

snjpverma

New Member
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.

NamesProduct Status
AlanReturned
BarbaraReturned
CharlieSold
DaveSold
AlanSold
HuzbertSold
BarbaraSold
InezSold
MarkSold
BarbaraSold
NorahSold


Also cross posted in
https://www.mrexcel.com/board/threads/vba-msgbox-if-duplicate-exists.1127478/
 

Marc L

Excel Ninja
Without the necessary in initial post like any forum expects for​
I just can tell you can use helper columns and formulas so without the need of VBA​
like you can also directly remove duplicates just using the Excel feature 'remove duplicates' …​
 
Top