How to remove row duplicates

  • Thread starter Thread starter SNAP TO GUIDES DON''T SNAP
  • Start date Start date
S

SNAP TO GUIDES DON''T SNAP

I would like to remove duplicates from a row and keep the first (row 1) data

Column A-part number Column B-desc. Column C-qyt.
row 1 456789 lock washer 1
row 2 456789 lock washer 5
row 3 456789 lock washer 10

desired result
456789 lock washer 1

TY in advance!
 
Why not in Cell D2 (assuming it to be blank) enter:
=IF(A2<>A1,"First","Repeat")
and copy down.
Then Auto-filter on "Repeat", and Delete ALL
Then Unfilter to only First(s)...
Delete Col D
 
Back
Top