“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

I need a formula to tell me if a product is standard, medium or large if i input length, width and height data worked with the following restrictions
Standard is:
Max dimension <= 52cm, next Max <= 33cm and Min <= 30cm Medium is:
Max dimension <= 120cm, next Max <= 80cm and Min <= 80cm Large is:
Max dimension > 120cm, or next Max > 80cm

Solved by B. L. in 18 mins

I need a formula or function to calculate the average of a series of cells but filtering out the top(MAX) and bottom(MIN) cell quantities

Solved by K. U. in 16 mins