Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



Reply
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
2nd most frequently occuring value Singh Excel Discussion (Misc queries) 3 March 2nd 09 11:35 PM
Error suddenly started occuring Richard Excel Discussion (Misc queries) 5 March 11th 08 01:15 PM
run programme error occuring harry buggy Excel Worksheet Functions 2 September 11th 07 12:18 PM
Re-occuring Inspection Dates Belarny Mic Excel Worksheet Functions 2 August 3rd 05 11:10 PM
How to set multiple filter values for a filter in the page fields Simon Lenn Excel Programming 1 December 29th 03 09:35 PM


All times are GMT +1. The time now is 04:18 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"