+ Reply to Thread
Results 1 to 3 of 3

Filter on multiple colums

  1. 03-24-2020, 04:59 AM #1
    simone1989
    simone1989 is offline
    Registered User
    Join Date
    03-24-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1

    Filter on multiple colums

    Hi all,

    I would like to set a filter on mutiple colums, which doesn't work with the standard filter. I tried the advanced filter but that didn't really work for me either.

    I made an example of what I am looking for, can anyone help me out? That would be greatly appreciated!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-24-2020, 05:32 AM #2
    Eastw00d
    Eastw00d is offline
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Filter on multiple colums

    And how about 1 helping column like in attachment?

    Cheers
    Erwin
    Attached Files Attached Files
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...
    Reply With QuoteRegister To Reply
  3. 03-24-2020, 09:47 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,787

    Re: Filter on multiple colums

    Hi & welcome to the board.
    To Or criteria with advanced filter you need to set it up like

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    		 Fase A Fase B Fase C
    2
    		 Fase A Fase B Fase C
    x
    3
    		 Text 1
    x
    x
    x
    		 A, B, C x
    6
    		 Text 4
    x
    		 C
    Sheet: Blad1
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter and unfilter colums in a table with same button
    By behrooz_chz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2020, 02:32 PM
  2. Read colums passed the filter in pivot table by using vba
    By Tom1212 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2016, 09:55 AM
  3. Formula required for comparing multiple colums to multiple colums
    By Pringgles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 07:23 AM
  4. Apply same Filter across multiple colums with different dates
    By Danimarie in forum Excel General
    Replies: 4
    Last Post: 02-17-2012, 12:26 AM
  5. array/lookup help - multiple references over multiple colums
    By cards52 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2009, 03:04 AM
  6. Convert single colum/multiple rows to multiple colums.
    By merlinxl in forum Excel General
    Replies: 15
    Last Post: 06-12-2008, 07:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1