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

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