Home |
Search |
Today's Posts |
#1
|
|||
|
|||
concatenate values/texts corresp. to a searched repeated value/tex
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 |
#2
|
|||
|
|||
Hi
not really sure what you're looking for. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
#3
|
|||
|
|||
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" wrote: Hi not really sure what you're looking for. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
#4
|
|||
|
|||
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 -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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" wrote: Hi not really sure what you're looking for. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
#5
|
|||
|
|||
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" wrote: 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 -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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" wrote: Hi not really sure what you're looking for. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
#6
|
|||
|
|||
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 -- Regards Frank Kabel Frankfurt, Germany K.S.Warrier wrote: 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" wrote: 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 -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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" wrote: Hi not really sure what you're looking for. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany "K.S.Warrier" schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions |