+ Reply to Thread
Results 1 to 11 of 11

Calculate who has the most repeat calls in the call center

Hybrid View

  1. #1
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Calculate who has the most repeat calls in the call center

    If I understood your requirement...
    In D2:
    =IF(COUNTIFS($A$1:A2,"<="&INT(A2)+TIME(23,59,59),$A$1:A2,">="&INT(A2),$C$1:C2,C2)>1,"Y","N")

    Same concept applies to F & H columns.

    Now, for EMPL what should be returned when there are more than 1 that meets condition?
    Ex: When there are more than 2 matching result, which of the EMPL should be returned? The original (i.e. earliest call) or one previous? What if original record was found 3 weeks prior? Should it be return EMPL from 2 week prior date, or go all the way back to beginning of record?
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  2. #2
    Registered User
    Join Date
    01-21-2014
    Location
    Florida, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Calculate who has the most repeat calls in the call center

    You're amazing!

    For EMPL, we only need the most recent touch-point assignment. Whoever got the call last was responsible for the customer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Determining answer rate for calls in call center
    By Paulyzee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2015, 08:19 AM
  2. Call Center Help - Determining Calls per Hour by Day of the Week
    By emeraldgsl in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-12-2014, 06:48 PM
  3. Calculating concurrent calls in a call center
    By achooi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2013, 12:17 PM
  4. Repeat call count for call center
    By arifmasum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2013, 10:03 PM
  5. Calculating concurrent calls in a call center
    By achooi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-19-2013, 07:49 PM
  6. Excel Formula - Calculating concurrent phone calls in a call center
    By achooi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2013, 05:03 AM
  7. [SOLVED] Call Center Management: How to calculate 'cost per call'
    By Denniso6 in forum Excel General
    Replies: 2
    Last Post: 06-25-2006, 12:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1