I am working on a very larger spreadsheet that goes out to columns CR and
beyond.

I am trying to calculate the Mode of a new inserted column. I basically
insert a new column, calculate some % growth rates in that column, and then
try to run the Mode function and the result keeps displaying a 0.

As I try to do this in other columns in some cases it works fine in others
it either displays the results of 0 or NAME#.

Can someone help me with this issue.

Thanks.