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