Combining data from multiple cells into one cell with commas
 

I have several cells containing data that have a common denominator that I
want to combine in one single cell with commas to separate the data.

I have tried the following formula (acquired from elsewhere on this blog):

=SUBSTITUTE(IF($A$9="20090501182755",$E$9&",","")& IF($A$10="20090501182755",$E$10&",",""),",","",COU NTIF($A$9:$A$10,"=20090501182755"))

However, instead of returning the data I want, it shows no data at all, not
even an error, just a blank cell.

Any suggestions? Thanks for your help!

Combining data from multiple cells into one cell with commas
 

I think it all comes down to your use of quotes around your A9 and A10
values.

If those are real XL recognized numbers in A9 and A10, then simply remove
the quotes from your formula,
OR ...
Make the values in A9 and A10 text values by adding a single quote to the
beginning of those cells.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"lawandgrace" wrote in message
...
I have several cells containing data that have a common denominator that I
want to combine in one single cell with commas to separate the data.

I have tried the following formula (acquired from elsewhere on this blog):

=SUBSTITUTE(IF($A$9="20090501182755",$E$9&",","")& IF($A$10="20090501182755",$E$10&",",""),",","",COU NTIF($A$9:$A$10,"=20090501182755"))

However, instead of returning the data I want, it shows no data at all, not
even an error, just a blank cell.

Any suggestions? Thanks for your help!