# 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