ExcelBanter - How to remove row duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to remove row duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/202073-how-remove-row-duplicates.html)

SNAP TO GUIDES DON''T SNAP

How to remove row duplicates

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!

JMay

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!

All times are GMT +1. The time now is 09:58 PM.