Excel.Tips.Net ExcelTips (Menu Interface)

Returning the MODE of a Range

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Returning the MODE of a Range.

Excel provides the MODE function to help you determine the most frequently recurring value in a range. For instance, let's say you have a table that contains sales orders. One of the columns indicates the number of items ordered in each order. Over time, you may have accumulated quite a bit of data in the table. If you wanted to know the most common number of items ordered, you could use the MODE function.

Suppose your items ordered column is F, and you have 1,200 orders detailed in rows 2 through 1,201. If want to know the most common number of items ordered, you can use the following:


The value returned represents the most commonly recurring value in the range. Thus, if 520 of your customers ordered 3 items, and the next most common was 314 customers ordering 4 items, then MODE would return the number 3.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2365) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Returning the MODE of a Range.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.