min value in range

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

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

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.

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

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

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

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