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.
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!