Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Using Excel's MODE function
Using Excel's MODE function
Use Excel's MODE function to display the most common value present in a particular range of cells.
The Mode function looks like this:
=MODE(cell range)
As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.
Added by Amanda on 26th November 2006
More Excel hints and tips, like:
- Change the Default Width of All Columns in Excel 2010
- autosum shortcut key
- How to apply the same formatting and data to multiple sheets at the same time in Excel 2010
 |
How To Estimate Time Required In Project Management The starting point for a project is a to-do list. It may appear simple to estimate time for each task and simply add up the total. In reality efficient project management and time estimation is and should be a little more complicated. What should a project manager consider when estimating the time required for tasks within a project? » Article: Project management courses london |
» Forum post: Excel VBA |
» Tip: Change case in Emails |
What is a variant?
When typing an email if the case is wrong press SHIFT + F3. This only works if Word is set as editor.
