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).
Bookmarks