+ Reply to Thread
Results 1 to 6 of 6

Requesting help returning text values from criteria based on multiple columns

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Requesting help returning text values from criteria based on multiple columns

    Hello all,

    I've hit a speedbump while trying to automate some processes in my report. I've been creating this report manually in order to help monitor SLAs in my team's environment, but it has been growing more painful and slow as we start to analyze more information. My situation is as follows:

    I need to return a value (a ticket number, or numbers) for each group on our team, that distills the result from these criteria:
    • The amount of days from the report date that the ticket has been open
      The status of the ticket
      The class of the ticket
      The assigned group

    TICKETID ASSIGNEDGROUP CLASS STATUS REPORTDATE NETWORKDAYS
    I12346 ONSITE INCIDENT INPROG 10/11/2013 0
    I12345 CADCAM INCIDENT QUEUED 10/10/2013 1
    398254 DATATEL SR QUEUED 10/9/2013 2
    I12344 ONSITE INCIDENT QUEUED 10/8/2013 3
    398253 ONSITE SR PENDING 10/8/2013 3
    398252 ONSITE SR RESOLVED 10/5/2013 4
    398249 CADCAM SR PENDING 10/4/2013 5

    As an example, I need to find and display the ticket IDs that belong to the ONSITE group and are: Incidents, not Resolved, and open 3 days.

    As an aside, COUNTIFS has worked beautifully to count total tickets and statuses across queues, and I can find the number of tickets that fit the bill for those criteria, but not the actual ticket numbers.

    Thank you for your time and any assistance/advice you can offer. I hope that I have explained in enough detail what I am trying to accomplish, but if I haven't, please let me know!

    Regards,
    David
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Requesting help returning text values from criteria based on multiple columns

    David

    I can do this very easily using a userform or drop lists on your workbook. Your Preference?

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Requesting help returning text values from criteria based on multiple columns

    Hi mehmetcik,

    Thank you for your response. I would prefer a userform if possible... thank you so much!

    Regards,
    David

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Requesting help returning text values from criteria based on multiple columns

    Phew

    This was a lot harder than I expected. Due to the three sorts of data in your columns

    But it was fun.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Requesting help returning text values from criteria based on multiple columns

    This was a lot harder than I expected.
    These were my thoughts as well! Thank you very much -- this fits the bill perfectly!

    Regards,
    David

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Requesting help returning text values from criteria based on multiple columns

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  2. Auto deletion of worksheets based on multiple criteria, and automatically returning values
    By iamrickdeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 01:52 AM
  3. Replies: 11
    Last Post: 01-02-2013, 10:14 AM
  4. Replies: 3
    Last Post: 09-06-2012, 09:07 AM
  5. Replies: 6
    Last Post: 02-07-2012, 08:21 PM

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