Using IFERROR and FREQUENCY functions in an array

[mcmassok]

Hi all,

I've been having some errors in trying to make data more presentable using the IFERROR function. Here's the whole shabang: {=IFERROR(FREQUENCY(A2:A1048576,C2:C1048576),"-")}

For some reason or another, it will not replace errors with the dash (-). Anybody have any ideas as to why or what I am doing wrong? I've attached the portion of the spreadsheet as to where I am having trouble. Unfortunately I cannot upload all of it. It is an automated system that updates based on an Access Database. I've cut off all data and functions past the 5,000 row.

Book1.xlsx

It wouldn't have anything to do with the fact that I am using a pivot table would it?

Thanks,

Clay Massok

[mcmassok]

I forgot, I also included a similar set up in cells G1:H2. Here, it is just used as a cell function and works fine.