This was great, the only problem is that the second part of the function
IF(A2=B2,B2,"")) isn't working. Any help would be great.

=IF(N20,REPT(J2,N2),IF(A2=B2,B2,""))

"Bob Phillips" wrote:



--
HTH

Bob Phillips

"KNS" wrote in message
...
I need to combine the text from multiple cells automatically based on
certain
conditions basically what I need would be something to the effect of
"If N20 print J2 "N2" times and if a2=b2 print b2" I hope that makes
sense
and someone can help me thanks. I'm using 2003.