+ Reply to Thread
Results 1 to 3 of 3

Multiple Criteria Data Filtering

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Canada
    Posts
    3

    Multiple Criteria Data Filtering

    I have one worksheet with about 900 rows and 70 columns of data, and I want to filter it into other worksheets based on several different criteria. Is there any way to set up the "output" worksheets so they can filter through the "input" worksheet and pick out the rows that have certain cells that meet the criteria I specify?

    Thanks for the help.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    I'd suggest VLOOKUP as ideal for that.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    11-06-2008
    Location
    Canada
    Posts
    3
    VLOOKUP won't work because there are several different criteria that must be met, and it is the same criteria for several different results. Here is an example of what I am trying to do:

    I have a database of several hundred m&a transactions, they range from a couple million to a couple billion dollars, corporate and asset sales, and it goes back to the early 90's. For the database to be usefull you need to be able to refine the criteria. For example I may only want to see corporate transactions, between $50 and $200 million dollars, since Jan. 1, 2007.

    I am fairly familiar with excel, and I know it is possible to use the AutoFilter option to sort the data, but it is not ideal for my specific application.

    Idealy I could select the entire range of data, and have some sort of filter, that would pull the values from the appropriate columns, if they meet the 4 or 5 different criteria, and drop them into a different worksheet. I have never seen anything that does this in Excel, and it may be that it just doen't exist.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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