Excel 2007 : Count Repeat Names

I have a spreadsheet with a list of names that missed an appointment throughout a time period. 'Column B' is the names. I want 'Column D' to show the number of times the patient missed an appointment. Does some know the easiest way to do this? I would like for it to ignore the space after the comma between last, first name in case someone accidentally forgets to add the space if possible.

I attached a template of what I need.

Thanks for any help in the right direction