About 45,100 results
Open links in new tab
  1. MINIF alternative | MrExcel Message Board

    Nov 3, 2021 · Hi, Was hoping I could get some help with getting minif formula. I was initially using below formula, on my laptop using office but doesn't seem to work on excel 16. …

  2. Minifs with OR criteria | MrExcel Message Board

    Aug 17, 2015 · Minifs with OR criteria Setofskills Oct 6, 2017 array data minif minifs or function S

  3. Power Query - "MinIF" type function. | MrExcel Message Board

    Jun 3, 2009 · Hello - I have a data dump where i get information on customer pricing. In some cases (but of course not all) I have tiered pricing where the customer gets a better price if they …

  4. Return blanks instead of zeros if no data in column (MINIFS …

    Mar 17, 2016 · I currently am using this formula: =MINIFS(AH$71:AH$120,D$71:D$120,$D$4) However, if there is no data in cells AH71:AH120, then it returns a zero. I want to formula ...

  5. Sumif, Countif, Averageif, maxif, minif; with dynamic column formula

    Jun 18, 2022 · Hi groovy people. This is my very first thread and it may be a doozy! I hope someone with supernatural abilities in excel can solve this one! So, all I want to do is get the …

  6. Combined Min & Max Nested Excel Formula | MrExcel Message …

    Jan 30, 2021 · I am wanting to calculate the maximum dividend payout in the excel worksheet below for my business.I “cannot pay out more than the cash available OR than what I have …

  7. Return Smallest Value greater than 0 | MrExcel Message Board

    May 1, 2022 · Dear Sir, I want a formula to return the smallest value that is greater than 0. Thank You.

  8. MINIF Function | MrExcel Message Board

    Nov 17, 2003 · I successfully wrote the MINIF function that I originally asked the board about. Thank You!! Bryan H.

  9. how to use minifs of datetime based on date - MrExcel

    Dec 24, 2010 · I have a column of datetime values. I'm trying to extract the earliest or min datetime based on the date criteria.

  10. Minif from Pivot Table | MrExcel Message Board

    May 2, 2012 · Hello Board, I've got a quick question for you. I am trying to evaluate some modeling output data. I have a database that contains a model cell, the corresponding gain …