How can I get the mode of a range?

L

Laurel

I would like to know the most frequently occurring number in a range on my
spreadsheet, but =mode(c4:u4) is invalid. It looks like it wants
=mode({1,3,1,5,... etc.). How can I convert my range into a form the Mode
function likes?

TIA
LAS
 
L

Laurel

Never mind. I discovered that I get this error if I don't have three or
more numbers as data in the range. I had put the function in before I
filled in all my data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MODE calc where more than one mode number! 2
The sum of the same function that is used for a range of cells 2
Unclear change tracking process 0
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
A couple questions BEFORE using Office 365 0
Can I link *.jpg files to Excel cells? 8
Finding the proper style field and the numbered paragraph value within the style 0

Top