How can I get the mode of a range?
 

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

How can I get the mode of a range?
 

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.

"Laurel" wrote in message
...
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