=mode(a4:a14)

[saintj0n]

I am getting an error #N/A when I use =MODE(A4:A14). How can I troubleshoot this? I have tried using other tables and no problem. There is nothing unusual about the data.

Any advice?

 

[T. Valko]

I am getting an error #N/A when I use =MODE(A4:A14). How can I troubleshoot this? I have tried using other tables and no problem. There is nothing unusual about the data.

Any advice?

Is there a mode? That is, is there some numeric value that appears more than once?

 

[Aladin Akyurek]

I am getting an error #N/A when I use =MODE(A4:A14). How can I troubleshoot this? I have tried using other tables and no problem. There is nothing unusual about the data.

Any advice?

It probably means that there is no number in A4:A14 which occurs more than once.

 

[saintj0n]

umm. yeah

There is no mode in my data because there are no recurring numbers! DOH!