If you're getting a circular reference error, make sure that your MODE
formula is not referencing the cell in which it is written. If the formula is
in G448, you shouldn't get this error unless it's from somewhere else.

As for the #N/A error, the MODE function returns this error message if all
values in the range are unique.

Rob
--
Powered by Creative Laziness


"JoAn" wrote:

I am unable to get the Mode Function to tell me the most frequently occurring
number in Column G from row 1 through 447. I place my cursor just below the
last entry in column G. I then insert the function =MODE(G1:G447) and I get
N/A references or circular reference error messages. There are no blanks and
the entire column G is formatted as numbers. PLEASE help. I've looked
everywhere!