Date | Reason |
1/25/2015 | red |
1/25/2015 | blue, red |
1/26/2015 | green, blue |
1/26/2015 | blue |
1/26/2015 | red |
1/27/2015 | green, red |
1/27/2015 | red, green |
<tbody>
</tbody>
Hello, I have a table with comma delimited data in the cells. I need to count the number of unique items in the lists per day, as in the table below.
red | blue | green | |
1/25/2015 | 2 | 1 | 0 |
1/26/2015 | 1 | 2 | 1 |
1/27/2015 | 2 | 0 | 2 |
<tbody>
</tbody>
This would be easy with a pivot table if the cells weren't comma delimited, but I'm having trouble with it separating the unique items. Is there a simple way to do this, maybe using the countif function? I'm using Excel 2013.
Thanks so much!