+ Reply to Thread
Results 1 to 3 of 3

Find duplicates & record their names & how many times they appear

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

    Find duplicates & record their names & how many times they appear

    I have this formula were it counts how many associates have contacted the help desk. It counts from "TSA Support" and displays the results on sheet "TSA Daily" starting at range A:23. However, I need it to base it on multiple criteria. Right now it just counts how many show up more than 2 times a day. I need it to count the ones that are more than 2 times a day & the "Reason for Contact (Main Category)" is equal to "Citrix Issues" & "OE Error Received" from sheet "TSA Support" column K. Any help would be greatly appreciated. This is my current code than needs to be modified.
    Please Login or Register  to view this content.
    I have also attached my workbook so you can see what is going on with it.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Find duplicates & record their names & how many times they appear

    In your example workbook the Main Category was in column J.

    Add these two lines.

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 01-18-2018 at 10:53 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

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

    Re: Find duplicates & record their names & how many times they appear

    This works amazingly - thank you so much!

+ 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. Replies: 4
    Last Post: 04-23-2015, 01:36 AM
  2. VBA Code Help PLS: Find Last Record on Sheet and Copy it Multiple TImes to Rows in Another
    By fadilrexhepi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2015, 08:33 AM
  3. Replies: 0
    Last Post: 03-15-2013, 08:32 AM
  4. Replies: 6
    Last Post: 11-27-2012, 12:03 PM
  5. [SOLVED] How to filter the names from a list of names without duplicates
    By jayait2000 in forum Excel General
    Replies: 6
    Last Post: 10-11-2012, 04:24 AM
  6. Macro Loop – Find Specific Times, Extract Date, Average Values of Times
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2010, 02:50 PM
  7. Replies: 1
    Last Post: 07-25-2006, 07:40 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