Get instant live Excel expert help to learn how to find max and min in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
My Min,Q1,Med,Q3,and Max #s are incorrectly shown in the chart. How can I fix this?
Solved by M. J. in 24 mins
Cell C20 = "6" if there is any pre-April 2008 service. However, if there is no pre-April 2008 service the individual completes cell C23/D23 with actual service between April 2008 and March 2014 (max 5 years 11 months). I have used a dropdown. Problem is how do I stop C23/D23 being completed if cell C20 = 6. There may be a better way to achieve this. But bottom line is that I need this section either to give 6 years service where the employee worked before April 2008 or their actual service if after. But the total service between April 2008 and March 2014 cannot exceed 6 years.
Solved by G. F. in 26 mins
I have a spreadsheet with temperature data for every hour every day for about three months across 2 dozen sites (columns). In a separate sheet I want to collect the excel min and max and difference between the two for each date. I thought there must be a way I can set up a formula to collect that info quickly.
Solved by A. L. in 18 mins
I'm having a problem coming up with a function that will insert the value of a cell based on whether or not the min excel value in the row belongs to the column.
Solved by Z. Y. in 27 mins
Hello, I have a spreadsheet with hourly recordings of temp and humidity across half a dozen sites (columns). In a separate spreadsheet I'd like to have the min max excel and difference between those for each site and each day.
Solved by O. H. in 16 mins
I am trying to enter the following formula in Excel, and I am being told that I have entered too many arguments. I thought however the max was 7, which I do not have. Formula entered:
=IF(AND((M8>40),(M8<=50)),((M8-40)*O8),IF(M8<=40,0),IF((M8>50),(10*O8)))
Purpose is simply to state that if Cell M8 is over 40 but under or equal to 50, then I want to subtract 40 from it, and multiply it by cell O8. If M8 is less than or equal to 40, just enter 0, if M8 is greater than 50, I simply need it to multipy 10 by cell O8.
Solved by T. C. in 13 mins
Hello,
I'm working on creating an excel formula. Starting in cell B2 I want to be able to figure out the maximum value between, g2, k2, o2, and s2. And then from there I want to list the category across the top that has the value for that has the max. From there I want to be able to drag that formula from b2 to b31
Solved by S. H. in 18 mins
hi, I have a table of numbers
4,3,2
7,9,9
5,3,1
9,8,3
In the first column, 4, 5, and 9 are the highest values in their row.
How do I calculate the sum of the max numbers in the column, and also maximum columns in excel? In this case, the sum is 4+5+9.
Solved by T. S. in 24 mins
I need a formula/function that will do the following:
Basically, if there is a "W" in the A row I need to subtract 1 from the previous B cell and the value for the corresponding B cell (A2->B2) must always be positive. Also, if the result in the A cell is an "L" then the result in the corresponding B cell needs to be negative and with 1 more or 1 less than the previous B cell depending on weather or not the previous A cell was a "W or an "L". Also, I need a second variant that will adjust for a MAX of "-5" that automatically resets the next value to +/- 1. (see examples)
Example of needed results:
A B
1 W +1
2 W +1
3 L -1
4 W +2
5 W +1
6 L -1
7 L -2
8 L -3
9 L -4
10 W +5
11 W +4
12 L -5
13 W +4
14 W +3
15 W +2
16 W +1
17 W +1
18 W +1
19 L -1
20 L -2
etc...
Example with max -5
A B
1 W +1
2 W +1
3 L -1
4 W +2
5 W +1
6 L -1
7 L -2
8 L -3
9 L -4
10 L -5
11 L -1
12 L -2
13 W +3
14 W +2
15 W +1
16 W +1
19 L -1
20 L -2
21 L -3
22 L -4
23 L -5
24 W +1
25 W +1
26 L -1
27 L -2
28 W +3
etc...
Solved by X. U. in 11 mins
I am trying to measure excel max, average and mim
Solved by D. U. in 26 mins