How to find duplicate values in Excel?

You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF

How to do a VLOOKUP on 2 columns

There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP

How to use the INDEX function in Excel?

Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.

VLOOKUP to the left in Excel

The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH

Search in a range of values with XLOOKUP

How to return a result in a range of values? With the XLOOKUP function, you can search in both direction, smaller or larger.

Transform List to Double-entry Table

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article

Create a Lookup Offset

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.

XLOOKUP is a Formula 1

XLOOKUP is the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and INDEX

How to use the MATCH function in Excel

The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas

How to use the VLOOKUP function?

The VLOOKUP function helps you to return a specific value inside a table. How to use it? It's not difficult.

Calculate between two values

The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.

Compare 2 Columns

You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values

Dynamic VLOOKUP research

You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data

Anonymise your data

Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed