creating bins in pivottables or powerpivot

Hello. I have a customer list in column A and a list of claims in column B. Sometimes the list in column B will be empty. I want to group the UNIQUE customers into bins based on number of claims filed. Sample spreadsheet attached.