concatenate values/texts corresp. to a searched repeated value/tex

[Guest]

Can someone among the group suggest a possible formula to
concatenate(combine) values/texts from a column A, corresponding to a
repeated value/text from another column B.

Thanks in advance
K.S.Warrier

 

[Frank Kabel]

Hi
not really sure what you're looking for. Could you give an example?

 

[Guest]

Hi,
Thanks for your immediate response.
If col A1:A10 contain values.. 8,1,6,4,1,7,2,2,1,0
&
col B1:B10 contain texts.. ma,ra,cha,ku,su,ke,A(La),si,sa,gu
How to combine the texts from col B corresponding to 1 in col A.
Here the answer expected is= ra su sa
or =ra,su,sa
I hope it is clear now.
Thank you
K.s.warrier

 

[Frank Kabel]

Hi
only possible using VBA. Try downloading MOREFUNC.XLL
(http://longre.free.fr/english) and try the following formula
=MCONCAT(IF(A1:A100=1,B1:B100,""),",")
and enter this as array formula with CTRL+sHIFT+ENTER

 

[Guest]

Hi,
Thanks for the response.I am not familiar with VBA.
Regarding array formula, whether pressing CTRL+SHIFT+ENTER should be done
after entering the formula in a cell.
Thanking you once again.
K.S.Warrier

 

[Frank Kabel]

Hi
instead of pressing the ENTER key after entering the formula you have to
press the 3 keys together.

As for VBA: Just install this addin and it should work