+ Reply to Thread
Results 1 to 3 of 3

Return Certain Data Based On a Specific Number Needed

  1. #1
    Registered User
    Join Date
    04-25-2016
    Location
    Virginia
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Return Certain Data Based On a Specific Number Needed

    Hello, I work in Call Center QA, and I need a formula to return a call incident number for our CSRs based on the number of scores needed to meet our SLA. For instance, if a CSR has taken 100 calls, we have to monitor 10 of those calls (10%).

    Please review attached spreadsheet: I have one sheet (Scorecard Tracker tab) set up to show how many calls each individual CSR has taken, how much we have scored, and how many scores are needed to have them at 10%. I have another sheet with the CSRs' names and all their call incident numbers (Raw Data tab). But I need a formula to randomly pull call incident numbers for each CSR from the Raw Data Tab based on the scores needed in either the Scorecard Tracker Tab. I would like this data to be populated in the Assignments Tab.

    Please help! Hoping to have this set up for May.
    Attached Files Attached Files

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Return Certain Data Based On a Specific Number Needed

    Hi
    I suppose you need a little VBA. See the code
    Code in Sheet Assignments - This code run when you press the hyperlink in G2 of that sheet
    Please Login or Register  to view this content.
    Note:If you change F1 or F2 in sheet 'Scores Needed' you must change the code according. The same occur for G2 in sheet Assignments

    See the file Scorecard Tracker Post for Excel Help(1).xlsm for clarification

  3. #3
    Registered User
    Join Date
    04-25-2016
    Location
    Virginia
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Return Certain Data Based On a Specific Number Needed

    Hi Jose, thank you for your response. Unfortunately, I don't think this solves my problem. I don't think I was clear enough in my question. Say for instance in the "Scorecard Tracker" tab, John needs 3 scores (H3). I need three incident numbers assigned to John in the "Raw Data" tab to randomly populate in A2:B4 of the "Assignments" tab. It will need to do this for all CSRs who have scores needed. Does that make more sense? Thank you so much for your help!

+ 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. Copy and paste data from master based on a specific format based on Invoice number
    By anandnair1983 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  2. Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  3. Return Number of Unique Valued Based On Specific Text
    By ljochmann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2015, 02:27 PM
  4. [SOLVED] Macro needed to copy data from master sheet to a number of specific sheets
    By krish2503 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2015, 04:42 PM
  5. [SOLVED] Formula to return score of 0-100 based on column of number data?
    By theronager in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-22-2013, 06:45 PM
  6. Replies: 6
    Last Post: 07-26-2012, 06:34 PM
  7. Replies: 4
    Last Post: 06-30-2006, 10:50 AM

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