+ Reply to Thread
Results 1 to 3 of 3

Table problems

  1. #1
    Registered User
    Join Date
    02-14-2015
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    16

    Table problems

    Hi All,

    I would like to use the table included in the sheet.

    This table shows me different groups which are staying in my event centre.

    I can filter the groups on arrival, departure, kind et cetera. but I now want to know how I can filter double.

    For instance, I would like to filter on kind, so I will only see a certain kind of groups and then on arrival date, from old to new (so earliest arrival dates first), so I have all the groups from that certain kind selected and then filtered from arrival old to new.

    Can somebody help me figure out how to do that. If I try to do that now, The filter on kind will go away when I filter on arrival after I filtered on kind.

    Thanks in advance,

    Tom
    Pic 1.png

    Table Sheet Groups.xlsx

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Table problems

    maybe start filtering from left to the right

  3. #3
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Table problems

    The "autofilter" as its called (there is an advanced filter option which is way more complicated and powerful) adds those filter drop downs to each column.

    You may filter on as many columns at a time as you like. Simply use 1 of the drop downs to apply a filter, then another. Each drop down that has a filter applied will have a small funnel icon on it to indicate that column is filtered. The order you filter in does not matter. Be aware that each subsequent filter will only allow you to select from options available after previous filters are applied*. Take for example this screenshot. I have column A and column C filtered.

    sffafgageaeg.PNG
    Last edited by Zer0Cool; 02-08-2018 at 10:40 AM.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

+ 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] Problems with sorting andf Pivot Table problems
    By Saturn in forum Excel General
    Replies: 4
    Last Post: 10-07-2012, 07:47 AM
  2. Problems with Pivot table
    By Ozwilly in forum Excel General
    Replies: 7
    Last Post: 02-27-2012, 02:12 AM
  3. Count If table problems
    By phoztek in forum Excel General
    Replies: 2
    Last Post: 06-20-2011, 10:40 AM
  4. Pivot table problems
    By beloosesky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2010, 12:29 PM
  5. table searching problems
    By stephen1000 in forum Excel General
    Replies: 0
    Last Post: 01-21-2009, 05:29 PM
  6. [SOLVED] Pivot table problems
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 12-12-2005, 10:40 PM
  7. [SOLVED] Pivot Table problems
    By Randy Starkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 10:25 PM
  8. Pivot Table Problems
    By Rachel Gonsior in forum Excel General
    Replies: 3
    Last Post: 03-21-2005, 04:06 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