min based on criteria

  1. K

    Need formula to return the earliest Date with the first blank "$ Amount" field that matches a specific ID

    Hi! I have a spreadsheet that we use to track contracts, Purchase orders, and Invoices/payments. I am trying to create a field that will show me the next soonest invoice date that doesn't yet have a dollar amount populated (because that date is the next invoice that we haven't yet paid... the...
  2. L

    EXCLUDE 0 FROM MIN

    Hi, I am obtaining the min date given several conditions. When one of the conditions is nonexistent, it gives me that one as the min value. How can I solve that? I am obtaining the...
  3. L

    MIFS with complex COUNTIF formula inside

    Hi! I am trying to find the oldest date in KPI!$G:$G meeting all the conditions of either these two formulas (I obtained the same result) -...
  4. D

    Max formula for multiple columns

    Hi I have a sheet where I am looking for a formula to add to C14,D14,E14,F14.G14 & H14 to calculate 15% of C13,D13,E13,F13,G13 & H13 up to a limit e.g. the maximum is 20,000 over a few months month. E.G if profit is sufficient in cells C14,D14 & E14 or any combination of columns where 15|% of...
  5. L

    Lookup Minimum value in a range

    I would like to lookup a value in a table and have it return the lowest matching value If I look up the age 6, it should return 39 If I look up the age 7, it should return 49
  6. D

    How to use MIN function whilst omitting 0 value within INDEX and MATCH formula

    Gday, I need to find the lowest number from a range of numbers omitting the value of '0' whilst using the MATCH and INDEX functions within the same formula. Have tried this combination but receive an error. =INDEX(D36:BXW36,MATCH(MIN(if(D38:BXW38>0,d38:bxw38),D38:BXW38,0))...
  7. J

    Swap Array for Non-Contigous range in MIN(IF formula

    Hi All, I have the following formula which works, but the ranges that I am using are now broken up. Is there a way to put in a non-contiguous range in their place? =MINIFS(B5:B16,C5:C16,">"&0) Basically what I am trying to do is pull through the min date where there is a result next to...
  8. G

    Formula or VBA for a Scroll bar to match min and max values of a variable cell?

    Hi everyone, In a table i have : E1= Apple; F1= 0.2%; G1= 1.5% E2= Banana; F2= 1.5%; G2= 3% E3= Pear; F3= 1%; G3= 4% E4= Cherry; F4= 4% ; G4= 10% E5= Peach; F5= 5% ; G5= 20% Column F represents the minimum % and column G represents maximum % In A1 i have a data validation drop down list...
  9. B

    Return Minimum value with multiple criterion

    Hello, I'm working on creating a formula to tell me the oldest outstanding invoice based on Job #. I have a pivot table that shows an outstanding amount, if any, for each invoice. Each customer has multiple invoices. Ideally, the user would input the job #, and the formula would return the...
  10. C

    Scores in a Range

    Hi I am looking for some help, been fiddling with excel most of last night but not any closer to solving this little problem. Lets say I have some test results, based on the % achieved you get some points (which will be used later in combination with other test results). Any score under 60%...
  11. P

    Finding the minimum value that is not zero for each sub-set of data

    Hi - I have a data set that is sorted by Member ID and each Member ID can have multiple transactions. In my desired outcome I only want the non-zero minimum value displayed for the group next to the corresponding transaction in each subset of Member ID's. See example below: <tbody> Unique ID...
  12. R

    Index and Match function for having maximum and minimum values

    I am trying to find out the maximum and minimum values in Index and Match function For example Nodes Sign Moment 1 +ve 54 1 +ve - 10 1 - ve 68 1 - ve - 15 1...

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