Identifying Duplicates

[weatherman711]

I want to know if there is a way of identifying duplicate entries w/in a column that outputs information from adjacent cells.

Here's my example:
I'm making a bill of materials and every part has a unique ID (column A), yet some of the parts have the same description (column B). I would like a formula or macro that outputs a list of the alternate ID's for each part that has a duplicate description (column C).

_____A______________B___________C_________
1...Part ID........Part Desc.........Alt. Part ID
2...P100...............Bolt...............P100, P355, P865
3...P101...............Hex Nut.........P101, P934
4...P260...............Shaft
5...P355...............Bolt..............P100, P355, P865
6...P356...............Washer
7...P832...............Flange
8...P865...............Bolt..............P100, P355, P865
9...P934...............Hex Nut.........P101, P934


I know about conditional formatting and highlighting duplicates, then using CTRL+F to find the matches and manually inputting matching ID's into a single column (or series of columns), but my list is very long and that would take too much time.

Can anybody help?

 

[Akashwani]

Hi,

Press alt F11, double click the Module, Click Run, Run Sub/UserForm.

Or

In 2007 click on the Developer tab, Macros, if Altparts is highlighted click Run.

Or

Insert a shape on your sheet, right click the shape, click Assign Macro, double click Altparts, click the shape and the code will run.

Good luck.

Ak

 

[weatherman711]

There we go! works like a charm, vba macro ftw! Thanks all!

 

[mirabeau]

Hi Mirabeau,

Wow, I really must learn vba.
Based on my sample data, that code is PERFECT, amazing, really amazing.

Thanks

Ak

Hey Ak,

Thanx for the feedback.

I guess sometimes I feel the same way about learning formulas (or formulae) - at which you seem to be pretty adept.