Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel
Tags: findthemostcommonorf, kutoolsexceltutorial, kutools
Published: 2020-09-17 07:29:49

---
title: Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel
published: true
date: 2020-09-17 04:30:50 UTC
tags: FindtheMostCommonorF,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/find-the-most-common-or-frequently-used-valueword-or-number-in-a-list-in-excel/
---

## How to Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel?

In this article, you will learn how to **Find the Most Common or Frequently Used Value (Word or Number) in a List in Excel Office 365** using **Kutools**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Steps to Find Most Common or Frequently Used Value (Word or Number) in a List:

To find the most common or frequently used value in a list, do the below instructions.

- In the below-given image, you can be able to see the example data in the spreadsheet.
- Let’s see how to use the **Find**  **Most**  **Common**  **Value** feature in Excel.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-60.png)<figcaption id="caption-attachment-14065">Example data</figcaption>

- You have to **select** the **blank**  **cell** to display the result.
- On the **Kutools** tab, **select** the **Formula**  **Helper** option under the **Formula** section, then **choose** the **Formula**  **Helper** option from the drop-down list.

![Choose Formula Helper](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/chrome_gShDquaods.png)<figcaption id="caption-attachment-14076">Choose Formula Helper</figcaption>

- It will open the **Formula**  **Helper**  **dialog**  **box** , kindly, do the following steps.
- You need to **select**  **Find**  **Most**  **Common**  **Value** option from the **Choose**  **a**  **Formula** box.
- You can **check** the **filter** box and **enter**  **common** into the text box to filter the formula.
-  In the **range** box, click the button to **select the input range** where you want to find the common value.
- Then, hit the **OK** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-20.png)<figcaption id="caption-attachment-14067">Formula Helper Dialog Box</figcaption>

- Now, you can see the most common value from the specified range is placed in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-10.png)<figcaption id="caption-attachment-14068">Result</figcaption>

From the above steps, you can learn how to find the most common value in a list in Excel using Kutools.

## Verdict:

In the above article, you can clearly understand the steps to **Find the Most Common or Frequently Used Value (Word or Number) in a List in Excel Office 365** using **Kutools. ** Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!