Get instant live expert help on max difference in array

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a max limit in bottle of 450ML. my current stock as per books is 64.400. Physical stock is 63.100. how to find min and max? Can i calculate the difference using excel?
Solved by B. Y. in 27 mins
I need a formula that returns values from min to max, from an array of 3 values. If there are repeats with those 3 values, it must return zero. i.e. column 1 is always the minimum column 2 is greater than column 1 or zero Column 3 is greatest value or zero there are not always 3 values in the array, in some cases value appear more than once in the array.
Solved by A. Y. in 23 mins
I have a MAX(IF formula that isn't populating all the dates from the data source in to the primary sheet and I don't know why? I am using ctrl+shift+enter to put it in to an array format
Solved by I. Q. in 28 mins
I know I am doing something wrong but I need help fixing it, I need to get the min and the max from a pivot table and get the difference and find the maximum rate of change calculator
Solved by F. F. in 16 mins
In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range and in cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match.
Solved by V. J. in 18 mins