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!”
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