+ Reply to Thread
Results 1 to 2 of 2

Advanced Filtering from multiple rows

  1. #1
    Registered User
    Join Date
    08-14-2018
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    6

    Advanced Filtering from multiple rows

    Good Afternoon,

    Here is my issue. I have been wrapping my brain around this for days and cannot for the life of me get it straight.

    1. I have a list of names, trainings, and training dates.
    2. Column A is for Name, Column B is for Completion Date, and Column C is for Training Name.
    3. Each training type has its own separate row for each person resulting in have "Smith, John" having 7 different rows for 7 different trainings.

    What I am trying to do is filter out all of the "Smith, John" rows if he is missing a specific training. In this case the training is labeled SST.

    I want to do this for the entire sheet keeping only the names of the people who have NOT taken this SST training. I have attached an example of what I am working on.
    Attached Files Attached Files
    Last edited by jedi4ce; 08-14-2018 at 01:14 PM. Reason: better title

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Advanced Filtering from multiple rows

    I'd add helper column.

    In D2:
    =COUNTIFS($A$2:$A$94,A2,$C$2:$C$94,"SST")

    Filter out anything >0. And you are left with anyone that has NOT taken SST training.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ 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] Easy filtering method via vba/formula/advanced filtering?
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 12:35 AM
  2. More advanced advanced filtering
    By Acceleracer in forum Excel General
    Replies: 2
    Last Post: 02-06-2014, 09:02 PM
  3. Advanced Filtering
    By JimmySmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2012, 09:53 AM
  4. advanced filtering
    By shane.granger in forum Excel General
    Replies: 2
    Last Post: 03-12-2010, 02:29 PM
  5. advanced filtering in XLS
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 08:05 PM
  6. [SOLVED] advanced filtering in XLS
    By Tina in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  7. advanced filtering in XLS
    By Tina in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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