+ Reply to Thread
Results 1 to 6 of 6

Help with multiple filter creation

  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    New Jersey
    MS-Off Ver
    2013
    Posts
    56

    Help with multiple filter creation

    I have created this excel sheet that I need to do multiple filters on. I have Column A set to filter by color because that was the only way I could get the column to filter the way I needed in because going down the column there were multiple headers that had sub categories below and i needed them to be associated with the proper header. The issue I have is that across column A above I have other Items I need filtered based on what filter is being displayed in column A. For example I have in column A the headers of Fruit, Food, Drinks color coordinated in red, green, blue they all have data underneath the headers. I have going across row 1 Outputs with healthy and unhealthy, healthy drink, unhealthy drink, dairy, meat. I fill out in each cell below unhealthy and healthy corresponding to each piece of data in column A with the word "check". What I want to accomplish is that when I filter Column A to show Just fruit for instance it also with display the unhealthy and healthy but it doesn't have to display for dairy and meat as fruit is either. Can this be done and if so how. Any help would be greatly appreciated. I am attaching a sample excel so anyone can visualize what I am trying to accomplish.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-29-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    24

    Re: Help with multiple filter creation

    Consider arranging your data into a table?
    Attached Files Attached Files
    Last edited by ocannon1; 08-21-2017 at 11:51 AM. Reason: upload

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Help with multiple filter creation

    Hi,

    Your table structure is wrong (sorry to say). You need columns like...

    Food - Name of the food or drink or exact product
    Type1 - Food or Drink
    Health - Healthy or UnHealthy
    Type2 - Dairy or Meat or Veg

    You can't have a blank column or row in your data if you want to filter it as a table.

    By trying to have columns that combine facts it keeps your table from working.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    07-17-2017
    Location
    New Jersey
    MS-Off Ver
    2013
    Posts
    56

    Re: Help with multiple filter creation

    I know the set up is incorrect in regards to a table the original format was on a website so obviously there are going to be spaces. My main concern is to be able to filter the food items on the side with its corresponding the columns in the output the checks in the website are actual check boxes.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Help with multiple filter creation

    Hi,

    Now I'm really confused

  6. #6
    Registered User
    Join Date
    07-17-2017
    Location
    New Jersey
    MS-Off Ver
    2013
    Posts
    56

    Re: Help with multiple filter creation

    look at my original post and the excel file

+ 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. VBA Advanced Filter table creation and use help
    By jeetkapadia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2017, 02:03 PM
  2. Need Macro for Advance filter and Workbook creation
    By alex101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2014, 03:44 PM
  3. Chart Creation - Multiple layouts
    By HARDING22 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-30-2012, 05:02 PM
  4. Excel file creation dates do not match the windows creation date.
    By alexthapyro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:14 PM
  5. List Creation from Multiple Tabs
    By scottkelley80 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 06-21-2010, 07:08 PM
  6. Creation formula with multiple criterias
    By s-vadik in forum Excel General
    Replies: 13
    Last Post: 10-24-2008, 02:35 AM
  7. [SOLVED] Macro for Multiple Form Creation
    By JB2010 in forum Excel General
    Replies: 1
    Last Post: 03-23-2006, 12:00 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