Hi! All,

I have a list of people in column A where the name of an individual appears multiple times.
And in column B, I have only two conditions - "Dealt" and "Not Dealt".
I want to count number of "Dealt" and "Not Dealt" for each individual.
So something like a count formula. Please advice.