#1
|
|||
|
|||
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?
|
#2
|
||||
|
||||
How about a Pivot Table . Attached is an example
|
#3
|
||||
|
||||
Perhaps Advanced filter to get unique IDs in column F and formula in G2 copied down?
If there are more than 2 instances of a CustomerID and more than 2 different statuses, the lower result takes precedence. See attached. |
#4
|
|||
|
|||
Thank you!
|
#5
|
|||
|
|||
Thank you the formula will work. Appreciate your help.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Collate information using unique ID | CarlosTJ | Excel | 2 | 02-11-2019 10:28 AM |
Indexed/Unique IDs | ID015 | Word VBA | 0 | 10-11-2016 03:15 AM |
Counting only the unique names in 3 columns on separate worksheets. | Ryga38 | Excel | 1 | 04-15-2016 07:21 AM |
Counting | dayjef | Excel | 4 | 02-23-2016 03:00 PM |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |