How to remove row duplicates
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
"SNAP TO GUIDES DON''T SNAP" wrote:
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!
|