I have a spreadsheet containing data from our support ticketing system. I have a formula that has been killing me and am looking for any help I can get!
I'm looking to count the total number of unique ticket numbers for each individual where the ticket had a activity of escalation. I also need to verify that the Call Driver is homes. Here's what I've tried.
b c f k
Activity Type Activity Logged By Ticket # Call Driver
Escalation Steve Smith 2885656 Homes
Escalation Steve Smith 2885656 Homes
Inbound email Steve Smith 2885656 Homes
Escalation Steve Smith 2890000 Homes
Escalation Steve Smith 2870000 Streets
=SUM(IF(FREQUENCY(IF(C:$C="Steve Smith",F:F)*(B:B="Escalation")*(k:k="Homes"),F:F)>0,1))
The result should be 1 because there is only one unique ticket # by steve smith that was a escalation for homes.
Thanks so much for any assistance!