I have a spreadsheet with many rows. I am quite familiar with pivot tables and perhaps I am just missing something, but I am unable to do what I want within a pivot.

Let's say in column A and B I have the following values

yellow chocolate
yellow chocolate
blue chocolate
yellow vanilla
yellow vanilla
blue vanilla
black strawberrry
red vanilla

I would like to report on how many unique flavors of ice cream there are by color. The resulting table would show:

yellow 2
blue 2
black 1
red 1

So rather than defineing a range and creating a pivot that would show the total count of flavors by color, I simply want a count of the unique flavors by color.

Thanks