Combining cells conditionally

[bxb7668]

I need to be able to combine several cells into on cell as a comma
separated list based on a criterion in another cell. For example:

A B
1 Part Color
2 123 Green
3 234 Red
4 222 Red
5 9874 Blue

On another sheet I like to have:

A B
1 Color Parts
2 Green 123
3 Red 234,222
4 Blue 9874

Is this possible?

Brian

 

[JulieD]

Hi Brian

Check out my website (www.hcts.net.au/tipsandtricks.htm) for a UDF called
CONCAT_IF - there's instructions etc ...post back if you need additional
assistance.

 

[bxb7668]

Thank you Julie. That works great!

Brian

Hi Brian

Check out my website (www.hcts.net.au/tipsandtricks.htm) for a UDF called
CONCAT_IF - there's instructions etc ...post back if you need additional
assistance.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

 

[JulieD]

you're welcome, and thanks for the feedback