# min value in range

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...