Subtotals order

  • Thread starter Lost in Microbiology
  • Start date
L

Lost in Microbiology

I have a client column and a result column. I am trying to summarize by
counting how many samples I have in a cascading fashion, so I want to know
first how many per client, then per client how many of each result. I tried
doing a subtotal count at each change in result, then a second subtotal count
at each change in client. But Excel kept cutting off the result in the last
few clients. Any thoughts?

The worksheet looks like this:
Client Result
0000 No virus
0000 No virus
0000 Flu A
0001 No Virus
0001 No Virus
0001 RSV A

All I want is a subtotal of each result per client.
i.e.
Client
0000 2 No Virus
1 Flu A
0001 2 No Virus
1 RSV A

Thanks!
 
Top