So I have table like this:

FIFI BLACK
FIFI RED
FIFI BLACK
FIFI CREAM
FIFI RED
FIFI RED
LOVE WHITE
LOVE PEACH
LOVE PEACH


In a seperate table on another sheet, I want to count how many different colours there are relating to the word in the left cell. So, as 'Fifi' comes in 3 colours (black, red and cream) and Love comes in 2 colours (white and peach), the result I would want to see is this:

FIFI 3
LOVE 2

I have been trying to do this all day! Can anyone help me out?

(I hope I've explained that well enough).