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
"bxb7668" wrote in message
...
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