• 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.

how to check if is there duplicates in any given column

jack abbey

New Member
how to check if in a given column is there any duplicates

for example, i use customer info with each name in a separate row
and i want to check if i entered by mistake the same customer twice
 

Irfan Aman

New Member
how to check if in a given column is there any duplicates

for example, i use customer info with each name in a separate row
and i want to check if i entered by mistake the same customer twice
hi jack,

you may simply follow the below steps to cater to your requirement.

1.
73146

2.
73147

3. your new entry will be ditected if found duplicate.
73148


regards,
 

jack abbey

New Member
thats terrific, thanks so much
however, i want it in a function code, so that it will automatically tell me if there are any duplicates, also it should give me either the cell reference or the actual data that is duplicated, is there any way to get that?
 

Irfan Aman

New Member
thats terrific, thanks so much
however, i want it in a function code, so that it will automatically tell me if there are any duplicates, also it should give me either the cell reference or the actual data that is duplicated, is there any way to get that?
Hi Jack,

you can give a try as below

73154

Kindly note, if duplicate value comes third time (or more than three times) in the column then the above solution will give the cell address value of first occurance cell only :p

Regards
 
Top