COUNTIF function

### 8 Ways to Count Duplicate Values in Multiple Columns in Excel

Microsoft Excel is the most useful data-tracking software. For datasets that have numerous worksheets or users or identity numbers, it is difficult ...

### 11 Easy Ways to Concatenate Rows in Excel

If you are looking for concatenating Excel rows, you've come to the right place. There are several ways to concatenate rows in Excel, and in this ...

### Generating Random Number Between Two Numbers in Excel

If you are looking for how to generate a random number between two numbers in Excel, you've come to the right place. There are several ways to ...

### Calculate Percentage in Excel Based on Conditional Formatting

In this article, I'll show you three excellent methods for how to calculate the percentage value in Excel based on the conditional formatting ...

### 3 Approaches to Calculate Average of Text in Excel

Normally the functions we use to calculate the average of something always take input of numeric values and calculate the average of numeric values. ...

### 3 Ways to Group Duplicates in Excel

Sometimes our Excel database may include duplicate values. These repetitions may be several instances of identical data. To determine the number of ...

### 3 Simple Ways to Count Blank Colored Cells in Excel

Microsoft Excel has a wide range of functions, but none of them can count the number of cells with respect to their color.  We can count the cells ...

### 4 Steps to Count Rows in Group Using Pivot Table in Excel

In this lesson, I'll demonstrate these approaches to use Pivot Table to Count Rows in a Group in Excel. Moreover, these techniques will enable you to ...

### 8 Easy Tricks to Generate Random Data in Excel

Sometimes we need to generate random data in Excel. In this article, we will show you how to generate random data in Excel with 8 easy approaches. We ...

### How to Apply Excel Formula to Change Text Color Based on Value

In this article, I'll show you three excellent methods on how to apply formula to change text color based on value in Excel. Furthermore, these ...