LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kuansheng
 
Posts: n/a
Default filtering unique data

Hi guys,

I have in column A part number, column B quantity and column C part
description. What i am trying to do is to filter out the unique entry
according to the part number and remove the dulpricates. Can anyone
help me out in this. Thanks

Before
part number quantity description
020-1234-14 1 upper barrel
034-1111-34 2 lower barrel
020-1234-14 1 upper barrel

After
part number quantity description
020-1234-14 1 upper barrel
034-1111-34 2 lower barrel

regards.
kuansheng

 
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
Filtering Data with Rank Function SteveC Excel Worksheet Functions 0 April 26th 06 10:18 PM
Filtering and Data Validation Susan Excel Discussion (Misc queries) 0 March 10th 06 06:30 PM
Inserting a new line in spreadsheet Rental Man Excel Discussion (Misc queries) 2 January 9th 06 04:55 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Unique and duplicate data between 2 Excel worksheets Greg Excel Worksheet Functions 0 August 9th 05 12:03 AM


All times are GMT +1. The time now is 08:23 PM.

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

About Us

"It's about Microsoft Excel"