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!”

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

Hi ! I am stuck... I have two columns of data : 1 is the Time (in seconds) 2 is a response from a practical test I have the maximum the second column can reach but would need to find at which time it reaches 90%. To do so I have calculated the approximate value 0.9*MAX(Column 2) and tried to use VLOOKUP and IF formulas to find the corresponding time but it doesn't display the right answer.
Solved by X. Y. in 23 mins
I need to figure out a Goal seek to figure out maintenance starting this year (Year 0) and is willing to decrease the overall Net Profit in Year 4 by $300,000 to accommodate this change. What would be the maximum Maintenance Increase rate for this year (Year 0) (currently 3%) that she could afford?
Solved by F. S. in 26 mins
I need a function for the following: CountA range of cells: if the count is greater than 2, the cell should contain the number "2"; If the count is 2 or less, the cell should contain the exact count. What the formula is for: List of classes a faculty can take. No matter how many they take, it can be no greater than 2 in the specified cell. Anything over two incorrectly affects another formula. The maximum number in the cell is always 2. Can anyone help me think through this?
Solved by K. U. in 29 mins
I'm trying to do a mean average and a mode average of a set of data from a maximum of 31 cells. I only want to average from the cells with numbers in and not the ones left blank. Any ideas?
Solved by M. F. in 28 mins
i need a formula that calculates the hours in column a, b, c, d, e, f, g and puts the sum in column h bu the maximum can only be 44 hours, anything over 44 hours needs to go in column i.
Solved by A. A. in 13 mins
I'm building a calculator to find out what how much income an investor receives when they take a loan against their investment. "Cash value" is the balance of the investment, annual policy loan and annual collateral loan is the amount they take out with the interest rate indicated. Is there anyway I can find out how to solve for the maximum income someone can take out without the "net cash value after loans" being negative?
Solved by S. A. in 22 mins
Looking to call the maximum from a large pool of data given a start and end date
Solved by D. H. in 24 mins
i want to highlight excel maximum and minimum in each row
Solved by C. A. in 24 mins
Complete the Statistics Table, at the bottom of the sheet, by calculating the average, standard deviation, median. How do you find the maximum or minimum value of a function (rows 103 – 107) for AS1, AS2, AS3 and the Overall Average columns
Solved by M. E. in 30 mins
If the maximum number of any one fruit exceeds 10 pieces in an order, or the total order exceeds 20 pieces (all fruit),then mark it with "Special Order". Otherwise, mark it with "No".
Solved by K. H. in 22 mins