Results 1 to 4 of 4

How do I populate a table based on multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    8

    Question How do I populate a table based on multiple criteria

    I have a list of inventory,'Register', with columns "Quantity on hand" & "Minimum Stock Level" as my criteria. I have a formula that I thought would work but in every cell it pulls the same cell. I want another table, on another workbook, to populate everything from the 'Register' if it meets the following criteria.

    Criteria 1 (ignore If "Minimum Stock Level" is blank), Criteria 2 (If "Quantity on hand"<="Minimum Stock Level").

    I know how to do this based on the criterias, however, the way I know how would not ignore blank cells and therefore I would have to filter out the blank cells. another person, not so familiar with excel, will be using this table to approve orders.

    I hope I am clear.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populate data in a table based on dropdown criteria
    By Ragsbr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2014, 03:23 AM
  2. [SOLVED] Populate table based on criteria from another table
    By m4k3n5h1 in forum Excel General
    Replies: 1
    Last Post: 03-29-2014, 12:55 AM
  3. [SOLVED] Automatically populate a table with slected data based on criteria
    By smithrog in forum Excel General
    Replies: 7
    Last Post: 07-01-2013, 03:52 AM
  4. Replies: 4
    Last Post: 09-07-2011, 05:49 PM
  5. Populate Data Based on Multiple Criteria
    By Kumara_faith in forum Excel General
    Replies: 4
    Last Post: 01-31-2011, 09:52 AM

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