ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to filter out multiple occuring partnumbers? (https://www.excelbanter.com/excel-programming/334086-how-filter-out-multiple-occuring-partnumbers.html)

dooku

How to filter out multiple occuring partnumbers?
 

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


Ron de Bruin

How to filter out multiple occuring partnumbers?
 
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" wrote in message
...

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





All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com