IF Function Archives

How to Count Unique Values in Excel Using Pivot Table

Oct 28, 2021 Excel Formulas

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)

Oct 10, 2021 Excel Basics

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

Oct 12, 2021 Excel Formulas

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)

Sep 26, 2021 Advanced Excel

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)

Sep 26, 2021 Excel Basics

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)

Sep 26, 2021 Advanced Excel

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

Sep 26, 2021 Excel Basics

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)

Oct 4, 2021 Excel Functions

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Oct 11, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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

Oct 10, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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 ...