Get instant live expert help on max function 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
how to use excel max if function? I get a value error for my If Function =IF(MAX(B2:M2<10),"E","")
Solved by G. H. in 11 mins
I got the following formula in my latest session:
=_xlfn.MAXIFS(Q:Q;C:C;C2)
But Excel 2016 does not have the maxifs function anymore, I need some help with changing to MAX(IF(
Solved by G. A. in 23 mins
Looking for a way to get a MIN result across a row of numbers but after a randomly chosen spot.
Ex.
Row 1 ( Commas are separate cells )
455,2,223,5667,32323,56,3,2323,34
I have used the MAX function to locate the MAX value in Row 1
EX - 32323
I need to Return a MIN result after that MAX number position.
EX - 3
The MAX will be in random spots every time I input data into a new sheet.
Solved by M. U. in 30 mins
how to show the player with the hight score in excel using MIN and MAX
Solved by D. C. in 26 mins
I have two separate MAX formulas in cells M19/M20.#
i wish to have both formulas in a MAX fuction in M19.
Solved by C. S. in 24 mins