criteria list

  1. D

    Criteria List

    Hello all, It was kind of tricky to come up with the best way to title this thread...my apologies for vagueness. I have a pretty big spreadsheet with a lot of detailed items. Rows A:CV are a bunch of details about an item. Rows CV:DH are a list of categories...if the item meets certain...
  2. H

    Populate Drop-Down List From Criteria

    Hi I am attempting to create a drop-down list which populates based on the value in another cell. For example, if cell A1 has the value "Supplier A" in it, then the drop-down list in cell B1 will contain all the products supplied by Supplier A. The issue I am having is the table on a separate...
    • heron
    • Thread
    • column criteria list drop down list supplier
    • Replies: 2
    • Forum: Excel Questions
  3. N

    Advanced filter issue

    Hi all, I've been using advanced filter with criteria range for quite long now but lately I noticed something which I am not sure if it's a bug or not. Please check the example belowe, I have the 1st column which I need to filter (column on the left) and the criteria range column (column on...
    • naderfikry
    • Thread
    • advanced advanced filter criteria list criteria range filter
    • Replies: 3
    • Forum: Excel Questions
  4. M

    SUMIFS with Cell Reference for Multiple Criteria List

    I have a series of formulas to calulate values from a table, and there may be one or more criteria for a given criteria range. For instance, there are two criteria listed for the Species range and three for the Product range in the example below...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top