Hi. I have a spreadsheet with a list of client names in column A that are
duplicated throughout the column dependent if they have bought products and a
statement saying either yes or no in column B. In a second sheet I have the
list of individual clients and I would like to count the amount of yes's or
no's against each client in the first sheet.

How do I do this?

Thanks