IF Function

How to Count Unique Values in Excel Using Pivot Table

In Excel, we need to perform various count operations, i.g. count text cells, count unique, counting duplicates, and many more. Today we are going to ...

How to Insert Date in Excel (7 Simple Methods)

There are several purposes for inserting dates in excel; tracking any information or for any date-time calculation you need to insert dates. Today we ...

How to Change Dates Automatically Using Formula in Excel

For easing your task you may demand automatic update of date, time sequence number, etc. Excel provides you with a feature for that. Today we are ...

Create a Unique List in Excel Based on Criteria (9 Methods)

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Make a Drop-Down List Based on Formula in Excel (4 Ways)

A drop-down list can help you to select any specific data in seconds. The drop-down list is a great helper when you are working with a large database ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to use IF Statement to Create a Drop-Down List in Excel

It’s quite often that you need to create a conditional drop-down list. The IF function is a useful one while dealing with any “conditional” ...

How to Use VALUE Function in Excel (5 Common Examples)

Excel provides several text functions to perform your desired text-related tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use VLOOKUP for Partial Match

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

VLOOKUP and Return All Matches in Excel (7 Ways)

There are several ways to apply VLOOKUP or vertical lookup in Microsoft Excel to return data based on multiple matches. In this article, you’ll get ...

How to Use IF ISNA Function with VLOOKUP in Excel (3 Examples)

Today I will be showing how you can use the VLOOKUP in combination with the IF and ISNA functions of Excel. One of the most important and widely ...

VLOOKUP to Find Duplicates in Two Columns

You may need to compare two columns in Excel to find duplicates or unique. In this article, we are going to show you how to find duplicates from two ...

VLOOKUP with Multiple Matches in Excel

Today I will be showing how to use VLOOKUP to extract multiple matches in Excel. One of the most amazing and widely used functions of Excel is ...

VLOOKUP with Multiple Criteria in Excel (6 Examples)

VLOOKUP function is generally used to look for a value in the leftmost column in a table and the function will return a value in the same row from ...

VLOOKUP SUM Multiple Rows (4 Ways with Alternative)

In MS-Excel VLOOKUP is the most used important function to search any data from a dataset or table. In terms of calculation, sometimes we may need to ...

ExcelDemy
Logo