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

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:41 AM
How to remove duplicates?	Lakewoodsale	Excel Discussion (Misc queries)	2	January 25th 08 10:31 PM
Merge and remove duplicates?	Shanel	Excel Worksheet Functions	1	January 23rd 08 10: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 05:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us