you're welcome, and thanks for the feedback

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"bxb7668" wrote in message
...
Thank you Julie. That works great!

Brian

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