critera variables

  1. M

    Reporting Text based on the numbers in two different cells

    Hello All, Excel novice here, trying to quickly learn how to embed and nest AND into IF(S) logic in excel (using 365 cloud on PC) Situation: We have people who are eligible for a reward based on two independent criteria of participation: (1) the quantity of their participation (i.e. the number...
  2. U

    VBA: Filter that contains with multiple criteria

    Hi Gurus, I have below sample raw data. I need to filter and move the information that contains certain words. Example I need to Copy the whole row that contains "Missed", "Chck", "Note"& "Check" (might add more) in the Subject Column. Account Subject Number x Note 1 Note 2 Note 3 001...
  3. H

    Find Latest value that meets Criteria

    I am wondering how can i find the latest information that meets my criteria, because all my table are run form a formula we the "Blank" cells will always read as a')', there fore i am having a Countif, Sumif, Maxif, etc issues, i am probably just typing my formula incorrectly. Based on the...
  4. E

    AVG, MED, 75th of filtered list, No Zeros

    I am attempting to find the average, median and 75th percentile in a list of data that I have, but I would like to exclude zeros from the calculations. Column D has various years (2012,2013,2014) and Column E has salaries. Essentially, I am trying to develop formulas that do these three things...
    • Excel1991
    • Thread
    • array critera variables help basic newb in excel please have mercy
    • Replies: 9
    • Forum: Excel Questions
  5. C

    Troubleshooting sumif - one formula throwing #Ref

    Edit: Not able to articulate.

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