commonly used numbers

[Guest]

How can I determine the most common number used in either a column or row.
Numbers ranging from 1 to 50 are listed in each cell randomly, and would like to determine which number i
used the most

 

[Harlan Grove]

How can I determine the most common number used in either a column or row.
Numbers ranging from 1 to 50 are listed in each cell randomly, and would like
to determine which number is used the most.

Read about the MODE function in online help.

 

[Guest]

This may be more than you need - Select the data to analize - Tools/Data Analysis/Descriptive Statistics/Summary Statistics - the mode is the number used the most.