min value in range

  1. M

    Finding MIN date in a range of incomplete data

    Hello, I am having difficulty finding a solution to make a range dynamic. I found my total row by using MATCH("Totals:",A2:A100,1)+1). Because I want to add addtional rows to the range (up to 100), I want to find the MIN of that range and I tried using this formula: MIN...
  2. G

    VLOOKUP function finding MIN value

    Hi, I got 2 columns I want to calculate the minimum value corresponding each number 1 and 2. I don't know how to put the min function in it. =VLOOKUP(C1:C2,A1:B11,2,False) 1 0.01 1 1 0.00 2 1 0.04 1 0.09 1...
  3. cvincent

    Highlight Min value in range greater than

    I have a column of percentages, and need to highlight the smallest value that is greater than 80%. This report is updated daily. I would like to know how to set conditional formatting to do this, or at least have a formula or run a macro to do this.
  4. R

    mimimum of dates with if statement

    Hi Everyone :) Having trouble putting the following statement together. I have various dates in column A and column B with some blanks mixed in. I need a statement in column C that will show the earliest date between column A & B. If both columns are blank then I need a return of: "Still in...
  5. D

    Max or min only if matches date

    How do you get a maximum or minimum number based on two criteria (MAX or MIN if within date specified)? DATE (Column A) ---- NUMBERS (Column B) ---- MAX OR MIN OF SPECIFIC DATE (Column C) 12/1/2010 -------- 30.00 ------ Maximum for 12/1/10 is: ? 12/1/2010 -------- 30.10 ------ Minimum for...
  6. D

    Find Smallest Non-Zero Value in Column

    Hi, Having a difficult time finding the difference between the maximum number and the smallest non-zero value that ignores text and any error messages. What I need to do is subtract the Maximum value in the column from the smallest non zero value. In the case below, it should take 7 minus 5...
  7. R

    find min value depending on range

    Hi I need to find the minimum value in row 2 for each account in row 1, for example row 1 row 2 111 50 222 20 333 80 444 40 111 40 222 50 Results would show 111 with a minimum value of 40, 222 with a minimum value of 20 etc etc I would prefer a formula that...

Watch MrExcel Video

This Week's Hot Topics

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
Top