 # Get instant live Excel expert help with MAX Function “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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
Question on how to calculate median, and how to find the minimum and maximum value of a function, from a large data set for different categories
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 max and min calculator and find 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