View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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!