View Single Post
  #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