count unique records in one column based on criteria in a different column

Hello

I'm trying to create a macro that will insert another tab that lists each name in column a and then counts the unique records in column b for each name. I've been searching the forums and can't find a solution but that could be because I'm not wording my search correctly. I attached a sample worksheet. The solution should be:

Jane R Doe - 8
Susie Q brown - 7
Bob M Jones - 6
Tony F Harris - 5

Any help would be greatly appreciated.

Thanks,
Ronna