Thread: How to remove row duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SNAP TO GUIDES DON''T SNAP SNAP TO GUIDES DON''T SNAP is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote