How to filter out multiple occuring partnumbers?

[dooku]

Hello,

I have along list of partnumbers which are connected to certain vehicles(motorcycles)
However many partnumbers occur multiple times in the same column because that part happens to fit more then one model of motorcycle.

I want to filter out all multiple occurences of those partnumbers so I end up with a list where a certain partnumber only occurs once in that column.

Regards
Dooku

[Ron de Bruin]

Hi

For code see
http://www.rondebruin.nl/copy5.htm

For a add-in see
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dooku" <[email protected]> wrote in message
news:[email protected]...
>
> Hello,
>
> I have along list of partnumbers which are connected to certain
> vehicles(motorcycles)
> However many partnumbers occur multiple times in the same column
> because that part happens to fit more then one model of motorcycle.
>
> I want to filter out all multiple occurences of those partnumbers so I
> end up with a list where a certain partnumber only occurs once in that
> column.
>
> Regards
> Dooku
>
>
> --
> dooku
> ------------------------------------------------------------------------
> dooku's Profile: http://www.excelforum.com/member.php...o&userid=25075
> View this thread: http://www.excelforum.com/showthread...hreadid=385930
>