Duplicate Code

[jthomas24]

Hello

I am trying to find a simple code to check if there is duplicate values. I have tried looking up code but nothing is making sense to me.

Any help would be appreciated

 

[Tom Urtis]

Your message can encompass a lot of scenarios, so some detail about what you are working with would be useful to someone trying to help. Also, are you sure you need code to do this? Many native formula approaches can determine duplicate values in a range.

 

[jthomas24]

I have code names for places (i.e Adjal) but i want to check if there is ever 2 identical codes. And if there is an easier way I can use it, but i have used conditional formatting and i dont really like the way it presents the duplicates,

 

[Tom Urtis]

How do you want the duplicates to be dealt with? Do you want them deleted, or maybe do you want a list of only unique values but keep the original list untouched? And how would a list be presented - - in a message box or on a different worksheet? What do you want the identification or deletion result to be presented as?

Edit -- I need to step away for a few meetings, so if someone else can can jump in, so much the better. Otherwise I'll be back this afternoon.

 

[jthomas24]

If there is a duplicate i want it to write text in column H saying duplicate

 

[Joe4]

If you have a list of values, and want to just check to see if there are any duplicates, one way is to use the COUNTIF formula, and count how many records are equal to the one on that row.
Any value greater than 1 indicates duplicates.

For example, if the data you are checking is in range G2:G100, and you want column H to say "Duplicate" if the value in column G is found more than once in the list, then you can use this formula in cell H2 (and copy all the way down to H100):

=IF(COUNTIF($G$2:$G$100,$G2)>1,"DUPLICATE","")