+ Reply to Thread
Results 1 to 2 of 2

How to filter multiple columns in order to keep all rows with at least one marking

  1. #1
    Registered User
    Join Date
    02-14-2020
    Location
    Kasterlee, Belgium
    MS-Off Ver
    MS Office 365
    Posts
    1

    Question How to filter multiple columns in order to keep all rows with at least one marking

    Hi,

    I'm new to the forum so I would like to start by saying that this forum has been very usefull in my earlier excel questions. Thank you all for that!

    For the following question I can't seem to find an answer so I would like to ask it here:
    As a new manager in a firm I'm trying to get an overview of all the tasks of the employees. To get this, I made a table in excel which gives a list of all the tasks in the firm on the one hand, and a list of all the people on the other. With this I get a clear view of how many people are working on the same task or on which task nobody is working on. And it also shows when a certain task is somebodys core task (c), normal task (x) or back-up for the task (b). To give you an idea of what I mean, I put an example (with all fictional names) in the attachement.

    Now do I also want to be able to compair the tasks of 2 (or more) employees, but that's where I get stuck. I know I can filter multiple columns by filtering and unchecking the blank cells. The problem is that when I do this, it only shows me the tasks that these employees have in common and it hides the rest.

    How can I filter this table in orde to keep all the rows with at least one marking? So for example: I want to compare Tom to Jimmy, how do I get to see all the tasks of Tom and all the tasks of Jimmy and hide all the other tasks? In my example are only a few tasks, but in my real table there are over 300 tasks, so you get why I'm looking for a way to filter in the list .

    Thanks in advance for the help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: How to filter multiple columns in order to keep all rows with at least one marking

    I think you will need vba & a helper column. Is it OK?

+ 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: 3
    Last Post: 01-18-2018, 12:20 PM
  2. Filter for multiple text words random order
    By siprian123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2017, 12:43 AM
  3. [SOLVED] How to order multiple rows according to the reference order?
    By cmokasak in forum Excel General
    Replies: 13
    Last Post: 07-26-2016, 02:00 AM
  4. Filter - Multiple Columns - Loop through Visible Rows issue
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2014, 05:30 PM
  5. How to sum row in order to multiple variables filter
    By asada in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2012, 10:02 AM
  6. Filter rows based on cell values in multiple columns
    By dionaqld1 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-25-2012, 09:13 AM
  7. Marking columns/rows
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-20-2008, 01:51 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