Hi

I have a worksheet that conatins about 1000 rows. It looks something like:-

RTM, Manager, Status

Amy, Danny, Closed
Amy, John, Open
Amy, Danny, Open
Amy, Karen, Close
Steve, Danny, Open
Steve, Danny, Open
Steve, Danny, Closed
Steve, Karen, Open.

I want to be able to run a macro/worksheet function that will output
RTM, Manager, Qty Closed

Amy, Danny,1
Amy John, 0
Amy, Karen, 1
Steve, Danny, 1
Steve, Karen, 0

I was thinking of using LOOKUP for the RTM but as far as I am aware this
will only count the number of closed for Amy but not differentiate between
Danny and Karen. Has anyone any ideas?
Thanks
TJ