Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to Find Duplicate Values in Google Sheet or Excel?

    • 1
    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 1.22k
    Comment on it

    Hello Friend,

    Many times we need to find and remove duplicate data in the spreadsheet and may of us do this task manually.

    But what if one have a large data containing thousand of columns will you then do this one by one, for me it will be impossible as it will be time consuming.

    So for this task First Sort your data in order from A to Z or Z to A then you can just use one simple formula as stated below:

    =IF(A2=A3, "Duplicate", "Not Duplicate")
    

    The above formula states that if column A2 data ( A is column and 2 is row number) is similar to A3 (A is Column and 3 is Row number) then it will print Duplicate else will print Not Duplicate.

    For example you can see the below screenshot:

    alt text

    The above screenshot Column A consists Email address in which some are duplicate, so in Column 2, I used the above stated formula which in results displayed me the 2 duplicates cells one is Row 2 and Row 6.

    One you got the duplicate data just put filter on your sheet and make visible only the duplicate data and delete all the unnecessary data.

    That's All !

    If you have any question or confusion please do comment. :)

 1 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: