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

I have a column with numerical values ranging from 1 to 900. I want to know if there is a formula to ask for the Max Value within that column, but that is in the 200 range. So, ask for the max of all the values ranging from 200 to 299.... So if my column values were 5, 17, 199, 205, 277, 310 and 550... I would expect the result from my excel formula to return 277. Does that make sense? Is there a formula to ask that?
Solved by O. Q. in 26 mins
I need a formula that puts absolute max calculator tax of 15 dollars for anything equal to or greater than 500
Solved by B. U. in 18 mins
I need a formula that will compare multiple columns, and return the column header name of whichever column had the highest value. I am using (INDEX($F$1:$K$1,0,MATCH(MAX(F2:K2),F2:K2,0))) , but one row had all the same values and the formula returned the first column header as being the "winner". This formula cannot distinguish when there are ties.
Solved by M. C. in 25 mins
Hi I am trying to calculate number of days between two days with max month of 30 days
Solved by D. Q. in 20 mins
i need help with a formula in "M" that relates to the minmax...not sure what to do.
Solved by D. B. in 15 mins
Hi, I need a formula to test if the number logic is true or not. the logic, Number X equal to by adding and using a fixed set of 6 numbers, with in 5 try max. Example: X=100, set numbers are 0.1,5,10.25,50). the above is logic is true because one of the way it can be done is (100= 25+25+50 +0+0.) if X cannot be equal than it false.
Solved by V. D. in 20 mins
G6, G7, G8 need to equal R17. the max each G cell can equal is U17 x 12 (months)
Solved by X. E. in 28 mins
Hello I am looking for a formula to pull the max number from a set of data, meeting 3 different criteria. Can you help me with max formula excel?
Solved by M. U. in 13 mins
I am trying to find the text value of something next to the max of the row and vlookup did not work
Solved by A. F. in 27 mins
Can you tell me why my max function excel isn't returning the latest New Value date when there are more than one dates for the same Lead ID?
Solved by E. B. in 14 mins