Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Duplicates dk New Users to Excel 15 March 28th 08 08:41 AM
How to remove duplicates? Lakewoodsale Excel Discussion (Misc queries) 2 January 25th 08 11:31 PM
Merge and remove duplicates? Shanel Excel Worksheet Functions 1 January 23rd 08 11:13 PM
how to remove duplicates ONLY within the same category Landa Excel Discussion (Misc queries) 5 April 26th 07 10:04 AM
Remove duplicates Tuttamay77 Excel Discussion (Misc queries) 4 May 12th 06 10:56 PM


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"