I have a rather large worksheet with multiple occurring part numbers in one column "A" and multiple different bin locations in another column "B". What I need to do is search column "A" for every occurrence of the current part number and pull every bin location associated with that part number into a new cell in column "C" separated with a comma or ";" excluding duplicates.
I have included an example sheet. Column "C" is my expected output.
Any help would be greatly appreciated!
Thank you
Last edited by Zombie79; 11-14-2007 at 11:00 PM.
Hi, sorry i haven't had time to look at your attachment but try this:
EDITED CODE BECAUSE I MESSED UP BIG TIME!
Please Login or Register to view this content.
Last edited by Simon Lloyd; 11-15-2007 at 07:06 AM.
Not all forums are the same - seek and you shall find
It does exactly what I need, only in every cell down the list, Basically I used "C" as an example. I would like it to run in what ever cell I'm current in, or a whole column. Pretty much scan whatever column I need (example: a:a -- but could be any column in the sheet) use the first cell in that column, usually starting at row 2 and running down the whole column.
Looking at the code that you pasted, you gave me a very nice starting point that I can play with and mold. If you have some free time and want to play around with it, I'll gladly accept your help!!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks