IF Function

How to Compare Two Columns in Excel Using VLOOKUP

There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare/find matches in two columns in excel using ...

Calculate The Difference between Two Dates in Excel

There might be a lot of reasons that you need to calculate the number of days between two dates in excel or the number of weeks, months, and years ...

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Compare Two Columns or Lists in Excel

While doing different tasks in Excel we often come across a situation where the matching and differences of two or multiple columns are required. ...

Most Useful & Advanced Excel Functions List

Excel has a wide variety of functions that you can utilize to accomplish a myriad of tasks. We have put a list of tutorials together on the functions ...

How to Compare Two Columns in Excel For Finding Differences

This is an interesting situation that often comes up. Namely, sometimes one needs to differentiate data into two different columns. There are so many ...

How to Use Form Controls in Excel

Introduction You can give your worksheets form-like functionality without ever having to use VBA. In order to achieve this, you will have to use ...

How to Use the Excel DAYS Function with a Practical Example

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, ...

Excel Pivot Table Calculated Field (How to Insert & Edit)

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. In this article, we shall learn ...

Excel If Function with Multiple Conditions (Nested IF)

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...

How to Make a Frequency Distribution Table & Graph in Excel?

You can make a histogram or frequency distribution table in Excel in a good number of ways. I have summarized total 7 methods in this article. In ...

ExcelDemy
Logo