COUNTIF Function

How to Use Excel IF Function with Range of Values

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

VLOOKUP to Return Multiple Values Horizontally in Excel

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

How to Sort Duplicates in Excel (Columns and Rows)

Sorting is one of the most common tasks in the daily use of Excel. You need to perform various sorts; sort multiple columns, sort dates, sort data ...

Find Matches or Duplicate Values in Excel (8 Ways)

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How To Search Multiple Items in Excel Filter

One of the more common tasks in Excel is filtering data. Probably in every aspect of your Excel use you are using the filter, filtering can be done ...

How to Sort Two Columns in Excel to Match (Both Exact and Partial Match)

While working in Excel, we often have to work with columns that are almost the same, and sometimes exactly the same. Today I will be showing how you ...

How to Calculate the Top 10 Percent in Excel (4 Ways)

At the time of working with numbers, we may need to find out or calculate the top 5, 10, or any specific percent in Excel. Generally, Excel provides ...

How to Use LARGE Function in Excel (6 Easy Examples)

When we need to find a specific largest value, like the 2nd or the 3rd biggest number in any dataset. The Excel’s LARGE function returns numeric ...

How to Use COUNTIF Function in Excel (10 Suitable Applications)

In Microsoft Excel, the COUNTIF function is widely used to count cells with a given condition or criterion. In this article, you’ll get to learn how ...

How to Use COUNTA Function in Excel (3 Suitable Examples)

In Microsoft Excel, the COUNTA function is generally used to count the cells containing the non-empty character(s) only. In this article, you’ll get ...

How to Use RANK Function in Excel (With 5 Examples)

The simplest technique to establish a number's relative position in a list of numbers is to sort the list in descending (from largest to smallest) or ...

How to Use RANDBETWEEN Function in Excel (4 Examples)

Today I will be showing how you can use the RANDBETWEEN function of Excel to get any random integer between two given numbers. Read More: How to ...

How to Use TRUE Function in Excel (With 10 Examples)

The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss the ins and ...

How to Use FALSE Function in Excel (With 5 Easy Examples)

The FALSE function in Excel is one of the logical functions in Excel which gives FALSE as output. Using this function, we declare the cell value as ...

How to Sort Data in Excel Using Formula

Today I will be showing how you can sort any data using formula in Excel. Download Practice Workbook How to Sort Data in Excel Using ...

ExcelDemy
Logo