Column A contains serial numbers most of them are duplicated.
Column B contains specific text.

Here is what I need to do.

A B

1 L
2 N
3 P
2 S
4 D
5 F
2 R

I want to combine the text from column B for every instance Column A
equals a certain number. For example If look up (2) in column A...I
want it to return (NSR).


--
natejohns7
------------------------------------------------------------------------
natejohns7's Profile: http://www.excelforum.com/member.php...o&userid=31597
View this thread: http://www.excelforum.com/showthread...hreadid=512898