SOLVED

New Contributor

7 Replies

# Re: Different Cells data into One for a specie ID based cells

See the attached sample workbook.

best response confirmed by aaajithk (New Contributor)
Solution

# Re: Different Cells data into One for a specie ID based cells

thank you soo much for your effort.

# Re: Different Cells data into One for a specie ID based cells

I'm able to use the formula you provided, but need to convert the numbers back to dates.  For example, the 6 digit number in the first column is correct, but the 5 digit number in the second column needs to be in mm/dd/yyyy format. Here's your formula for reference. Thank you!

 =IF(\$B116=\$B115,"",TEXTJOIN(", ",TRUE,IF(\$B:\$B=\$B116,C:C,"")))
 433890 44420 433899 44245, 44244

# Re: Different Cells data into One for a specie ID based cells

Use something like the following, adjusting the ranges:

=IF(\$A2=\$A1,"",TEXTJOIN(", ",TRUE,IF(\$A\$2:\$A\$11=\$A2,TEXT(C\$2:C\$11,"mm/dd/yyyy"),"")))

By the way, why did you mark your own reply as the best response?

# Re: Different Cells data into One for a specie ID based cells

I think that was the person you initially helped. I found this string and seen that it fit what I was looking for. Your response is best!!

# Re: Different Cells data into One for a specie ID based cells

My apologies, I see now that you're not the original poster.