Excel Formulas

How to Compare Three Columns Using VLOOKUP in Excel

The VLOOKUP function is a lookup and reference function to find and fetch data from a range in Excel. It finds and compares values by rows for a ...

How to Remove Characters in Excel (6 Methods)

While working with a large dataset, removing characters manually when needed is not a wise way. In this article, we will show you how to remove ...

How to Use Excel IF Between Multiple Ranges: 3 Easy Approaches

Here we’ve got a data set with the Names of some students and their Marks in Physics and Chemistry. Method 1 - Combining IF and OR Functions in ...

Excel Count Number of Cells in Range (6 Easy Ways)

Counting the number of cells is a basic task in MS Excel. There are a lot of methods to do it. In this article, I’ll show 6 easy methods including ...

How to Find Value in Column in Excel (4 Methods)

Let's take a dataset of some customers in a Super shop with the Customer ID, shopping Amount on a particular date, and also a Total if they bought ...

How to Count If a Cell Contains Any Text in Excel (4 Methods)

While analyzing, organizing, or processing data in Excel, you may feel the necessity to count cells based on the data such as text that the cell ...

How to Use Excel to Count Rows with Value (8 Ways)

There are several Microsoft Excel functions to count rows with a value in Excel. In this article, we are going to know about them with examples and ...

How to Use COUNTA Function with Criteria in Excel (4 Methods)

While working with a large dataset, sometimes we need to know the total number count of some certain dataset no matter whether it is a text or ...

Count One Column If Another Column Meets Criteria in Excel

While using Excel, you may need to count for different values based on some specific criteria. Excel shines with enormous features to count different ...

How to Match Multiple Columns in Excel (5 Suitable Ways)

If you are looking for some of the easiest ways to match multiple columns in Excel then you might find this article beneficial. Sometimes it becomes ...

Automatically Number Rows in Excel (10 Easy Ways)

Looking for ways to automatically number rows in Excel? Do not worry, we are here for you. In this article, we will describe 10 easy ways to do the ...

Editor choice Automatically Number Rows in Excel (10 Easy Ways)

How to Compare Three Columns and Return a Value in Excel

We may need to extract data by comparing three columns or to get an insight into data we may need to compare three columns. In this article, I will ...

Count Blank Cells with Excel COUNTIF Function: 2 Examples

While working with a large number of data, you can find several bank cells in your worksheet. As a result, it sometimes gives us different results or ...

How to Count Empty Cells in Excel (4 Suitable Ways)

Many times, the database might contain empty cells. One would like to count the empty cells. Microsoft Excel has some amazing formulas and tools to ...

How to Remove Characters from Left in Excel (6 Ways)

While working with Microsoft Excel, we can extract any number of texts from the beginning, middle, or end using functions and formulas. On the other ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo