Hello, I'm having issues with Excel's Frequency function. The information in this example is taken from the CTR SHIFT ENTER book. The array formula =FREQUENCY(A5:A17,C5:C9) in cells E5 to E10 of the solution calculates the results. see below:
(sec) Upper Limits
RESULTS already on sheet
My problem is I am copying the formula EXACTLY as above and pressing CSE into the cells H5:H10 but my results are all coming back as 1 which seems to be only counting the lowest limit in my bin_array. I have checked and the formulas match all the way down.