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

help with Max and Min function. Used for calculating revolver credit line draw/paydown

Solved by T. A. in 19 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

MAX MIN formula for revolving line of credit

Solved by K. Y. in 24 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

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