counting unique id and adding a value
In the attached spreadsheet I want to count the different status for that the unique customer id has. The card can have more than one status so I want to be able to assign a number to the different status (in spreadsheet) What formula is best to use?
|