+ Reply to Thread
Results 1 to 3 of 3

More advanced advanced filtering

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    San Francisco
    MS-Off Ver
    Excel 2007
    Posts
    1

    More advanced advanced filtering

    Hey Everyone,

    I have a fairly complex filtering problem that I cannot figure out.

    This is my first post so please forgive any missteps. Thanks in advance for your help.

    I have an spreadsheet with ~3500 rows and 6 columns. Every cell in every row in the first two columns have values in them. Every name in column A is unique and every location in column B is unique.

    Cells in the columns E&F have values in either E & F, E but not F, F but not E. Column E values are values from a list of about 400 (Let's call this this Makes). Column F values are values from a list of about 900 (Let's call this list Models)

    Column C&D are blank. From the 3500 rows, I need to identify which rows will require me to fill C&D based on the cells' E&F combinations. There are about 50 combinations of E&F that I need to filter for. Each combination uses a different set from the list of Makes and a different set from the list of Models.

    Is there a way to filter a sheet on column E by a set of values (OR relationship for the values in column E) AND also on Column F by a set of values (OR relationship for the values in F)?

    The size of these sets can be so large that using the advanced filtering methods here do not suffice.

    Any ideas would be greatly appreciated. Thanks again!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: More advanced advanced filtering

    Post a workbook with a subset of your data, and show an example of desired output?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,013

    Re: More advanced advanced filtering

    Hi and welcome ot the forum

    Yor situation is a bit hard for me to visualize
    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] advanced filtering
    By GIS2013 in forum Excel General
    Replies: 5
    Last Post: 05-02-2013, 07:10 AM
  2. advanced filtering in XLS
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 08:05 AM
  3. [SOLVED] Advanced Filtering
    By CFL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. advanced filtering in XLS
    By Tina in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Advanced Filtering
    By Stephen in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 12:05 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