DataFilterAdvanced Filter

That has a unique records option

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kuansheng" wrote in message
oups.com...
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