#Excel Short and Sweep Tip #11 (Most Frequent Item in Column) by David Hager

Have you ever had the need to return the most frequent item from a column range? The item can either be a number or a string. To do this, use the following formula.

=INDEX(ListRange,MODE(MATCH(ListRange,ListRange,0)))

where ListRange is a single column range.

 

Advertisements

One thought on “#Excel Short and Sweep Tip #11 (Most Frequent Item in Column) by David Hager

  1. Pingback: #Excel: Building a Frequency Summary Table Based on an Excel List by David Hager | Excel For You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s