Removing duplictaes

    Could anyone assit in how to remove duplicates?


    exact duplicates or "near" duplicates do appear at times for example:


    If you like I could send you the excel file to give you a better understanding.


    But essentially, the company can operate in different product sectors or can be located in different provincial locations:



    AlmasPelliSasDiMassaroAlessandroC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC
    AlmasPelliSasDiMassaroAlessandroEC


    ApisSRL
    ApisSrl
    ApisSrl
    ApisSrl
    ApisSrl



    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
    AIPASpaAgenziaItalianaPerPubblicheAmministrazioni


    AFiorDiPelle
    AFiorDiPelle
    AFiorDiPelleDiReginatoSonia
    AFiorDiPelleDiReginatoSonia


    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzaCommercioEsteroSRL
    3PRappresentanzeCommercioEsteroSrl


    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPAECSAS
    ConfartDiTosanaPierachilleECSAS
    ConfartDiTosanaPierachilleECSAS


    thanking you in advance

    removing dupes


    When you turn on the "filters", the down-arrow shows you a list of "unique" entries. This list can be generated using a new temporary worksheet.


    In a temp worksheet, copy a selected column of source data into column-A. Sort it. Copy cell A1 into B1. Select column-A. Select Data, Filter, Advanced Filter. In the pop-up, do the following:
    select radio button for Copy to another location,
    click inside of criteria range, then select cell B1
    click inside of copy to, then select cell C1
    select Unique records only
    finally, click OK
    This should result with all "unique" records appearing in column-C.


    Hope this helps,
    Al

    If the data begin from cell A1


    B1:
    =IF(COUNTIF(A$1:A1,A1)=1,ROW(),"")
    then drag down to the last row of the data in col.A


    C1: displays unique records
    =IF(ROW(A1)<COUNT(B:B),INDEX(A:A,SMALL(B:B,ROW(A1)),1),"")
    then drag down


    copy entire columnC and paste special/values


    Jindon

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login