Combining data from multiple cells into one cell with commas

  • Thread starter Thread starter lawandgrace
  • Start date Start date
L

lawandgrace

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&",",""),",","",COUNTIF($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!
 
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!
=====================================================

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&",",""),",","",COUNTIF($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!
 
Back
Top