Frequency data array limit

[Peter DiSantis]

It looks like I have hit a limit on the frequency data array.
=FREQUENCY('Early-Late PU Report'!$N$6:$N$13500,Sheet2!A3:A51)

I have over 88,000 lines of data and I cannot reach beyond 14,000.

I culled the file to 14,000 lines to upload (5.6MG). Apparently I reached an upload limit, too. Here is the Dropbox link to the complete file (+16MG).
https://www.dropbox.com/s/asab2thgcvl4qrx/Early-Late PU Report.xlsx?dl=0


HELP!!

Thanks in advance,
A Newbie,
Pete

 

[NARAYANK991]

Hi Pete ,

I do not know what you are talking about , but from what I can see , you have some error values in column M and because of that in other columns , in rows :

13866 , 43405 and 64757

Can you first correct these and then explain your problem in more detail ?

Narayan

 

[jeffreyweir]

Peter - instead of using FREQUENCY, how about putting the data into a PivotTable, grouping the Pivot by the bins you need, then dragging one of the fields over to the VALUES area and changing the aggregation to COUNT?