Hi,

Please download and install the following addin
(http://download.cnet.com/Morefunc/30...-10423159.html) and then use
the following array formula (Ctrl+Shift+Enter)

=SUBSTITUTE(TRIM(MCONCAT(IF($C$6:$C$10=B14,$B$6:$B $10,"")," ")),"
SPPT",",SPPT")

B6:B10 has the area and C6:C10 has the code. B14 holds the code

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pran" wrote in message
...
Stan,

As below is sample work book....

AREA CODE
SPPT No. 0130 SHGB No. 72/Kanci Kulon
SPPT No. 0132 SHGB No. 72/Kanci Kulon
SPPT No. 0131 SHGB No. 72/Kanci Kulon
SPPT No. 0153 SHGB No. 75/Kanci Kulon
SPPT No. 0154 SHGB No. 75/Kanci Kulon
etc etc

So, i wish that :

CODE AREA
SHGB No. 72/Kanci Kulon SPTT No. 0130, SPPT No. 0132, SPPT No. 0131
And So on...


Please help








"stanleydgromjr" wrote:


Pran,

Please post your workbook (or sample workbook) - scroll down and see
"Manage Attachments".


Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile:
http://www.thecodecage.com/forumz/member.php?userid=503
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=115352