IF function that searches one column and lists the results in a paragraph

Originally Posted by utahmoose

That finds the right values, but puts it as "catgoatdog". Any suggestions on how to separate them to "cat, goat, dog"? Or do I need to just do that manually you think?

Thanks!

With my method, you can change the formula in D2 to this:

=D1&IF(OR(LEN(D1)=0,LEN(C2)=0),"",", ")&C2

then copy this down to give you the names separated by a comma and space.

Hope this helps.

Pete