String multiple text per conditions

Hi all,

Trying to concatenate cells if they meet specific criteria ie:

A1 - dog
A2 - dog
A3 - dog
A4 - cat
A5 - cat
A6 - cow
A7 - cow
A8 - cow

Then in B1 if searching all of A:A and the result is "Dog" then put the amount of "dog" in the cell e.g "dog, dog, dog"

B2 if searching all of A:A and the result is "Cat" then put the amount of "cat" in the cell e.g "cat, cat"

I hope this makes sense. Thanks all inadvance. I have attached an example of how it should look once working.

To get exacly those results you can put this formula in D2 copied across

=REPT(D1&", ",COUNTIF($A:$A,D1))

......but I suspect that you have a "real" problem that isn't as simple......

=COUNTIF(A:A,"=cat")
or perhaps not as i just re read the post!

I like that one oldchippy......

Of course my version left a trailing comma space, one other option would be

=SUBSTITUTE(REPT(", "&D1,COUNTIF($A:$A,D1)),", ","",1)