+ Reply to Thread
Results 1 to 2 of 2

Formula to lookup the most out of list and get cell text

  1. #1
    Registered User
    Join Date
    11-29-2017
    Location
    Clearwater, FL
    MS-Off Ver
    2016
    Posts
    47

    Formula to lookup the most out of list and get cell text

    On sheet "TSA Daily" in cell A23 , I want this formula to search within column A for today's date on "TSA Support" worksheet & if it is equal to today's date then look in column K & if it says "Triage Created", "System Issue" & if that is there then look at column E to find out who it was.

    Then:

    If that name appears more than twice, I want their name to appear on TSA Daily in cell A23. In Cell B23 I want it to count how many times their name appears that day only if all the above criteria was met! I have included a sample workbook to help with the details.

    I would want everyone's name that appears more than twice within those criteria to show there in have them in descending order so the most at the top and the least at the bottom!
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Formula to lookup the most out of list and get cell text

    Here ids how I would handle it: with a helper column and a pivot table.

    The helper column is called Meet Criteria and has the formula: =AND(INT([@[Date/Time]]) = TODAY(),OR([@[Reason for Contact (Main Category)]]="Triage Created",[@[Reason for Contact (Main Category)]]="System Issue"))

    Then I built a pivot table with this as the report filter. The count of associate is sorted highest to lowest. About the only thing to remember is to refresh the pivot table.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Partial lookup from text string, return value from lookup list
    By TotallyLost in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-13-2016, 12:14 PM
  2. Replies: 7
    Last Post: 12-14-2015, 01:20 PM
  3. Formula to lookup a list and assign a category to another list
    By darrenjfox in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2014, 12:05 PM
  4. [SOLVED] Formula to lookup up text in a table and list in sequential rows
    By Brett.Olbrys in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-23-2013, 10:20 AM
  5. Replies: 12
    Last Post: 07-30-2013, 11:52 AM
  6. Formula that returns the text in another cell NOT a Lookup
    By Cammyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2013, 08:28 PM
  7. [SOLVED] Using IF formula to show what text is in the cell from ddown list
    By Clark in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2006, 03:25 AM

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