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