Concatenate by checking a condition

  • Thread starter Thread starter Senthil
  • Start date Start date
S

Senthil

Hi,

I am trying to concatenate cells after checking the condition. For example

A B
1 0
1 A
1 B
2 0
2 1
2 B

I would like to check the value of A and concatenate B. For A = 1, I am
looking for 0 A B. For A = 2, I am looking for 0 1 B.

Is there a function to do it automatic?

Thanks
 
Nothing built in to do this. There is a free add-in that has a function that
will do this:

http://www.download.com/Morefunc/3000-2077_4-10423159.html

Then you can use an array formula** like this:

=TRIM(MCONCAT(IF(A1:A6=1,B1:B6&" ","")))

Note that the resulting string can't be longer than 255 characters.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
Valko, Thanks for your help. I installed the add-in function that you have
suggested, I am getting the error message "#NAME?". I couldn't quite
understand what to do with array formula? Can you please help.
Thanks.
 
Valko, I had to restart my m/c after the download installation. It works
pretty good.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top