Home

uplicates

%3CLINGO-SUB%20id%3D%22lingo-sub-725250%22%20slang%3D%22en-US%22%3Euplicates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725250%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20highlight%20and%20remove%20complete%20ROWS.%20i%20can%20only%20find%20a%20way%20to%20highlight%20duplicate%20cells%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-725250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-725340%22%20slang%3D%22en-US%22%3ERe%3A%20uplicates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725340%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367738%22%20target%3D%22_blank%22%3E%40Okkie75%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BOn%20the%20far%20left%20side%2C%20move%20your%20cursor%20over%20the%20row%20number%20that%20you%20would%20like%20to%20delete%20(you%20should%20see%20a%20black%20arrow%20pointing%20right).%20Right-click%20and%20choose%20%22%3CU%3ED%3C%2FU%3Eelete%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3CP%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-727445%22%20slang%3D%22en-US%22%3ERe%3A%20uplicates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727445%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%20thank%20you.%20the%20challenge%20is%20to%20first%20identify%20duplicate%20rows(rows%20with%20the%20same%20data)%20.%20to%20delete%20the%20row%20is%20easy%2C%20but%20to%20identify%20which%20rows%20in%20a%202000%20row%20report%20are%20duplicates%20is%20the%20part%20I'm%20struggling%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-728281%22%20slang%3D%22en-US%22%3ERe%3A%20uplicates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728281%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367738%22%20target%3D%22_blank%22%3E%40Okkie75%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20your%20entire%20range%2C%20on%20ribbon%20Data-%26gt%3BRemove%20Duplicates.%20Here%20keep%20only%20column(s)%20in%20which%20you'd%20like%20to%20find%20duplicates%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20458px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121601iF57A1B2C57C00A69%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOk%20then.%20First%20of%20duplicated%20rows%20will%20be%20kept%2C%20other%20removed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Okkie75
New Contributor

Is there a way to highlight and remove complete ROWS. i can only find a way to highlight duplicate cells

3 Replies

Hello @Okkie75,

 

 On the far left side, move your cursor over the row number that you would like to delete (you should see a black arrow pointing right). Right-click and choose "Delete"

 

Hope this helps!

PReagan

@PReagan  thank you. the challenge is to first identify duplicate rows(rows with the same data) . to delete the row is easy, but to identify which rows in a 2000 row report are duplicates is the part I'm struggling with.

@Okkie75 

 

Select your entire range, on ribbon Data->Remove Duplicates. Here keep only column(s) in which you'd like to find duplicates

image.png

Ok then. First of duplicated rows will be kept, other removed.