WTF with XLOOKUP Function

WTF with XLOOKUP Function

NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...
5 Ways to Lookup Unique Values in Excel

5 Ways to Lookup Unique Values in Excel

Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is to...
7 EXCEL TABLES BEST KEPT SECRETS

7 EXCEL TABLES BEST KEPT SECRETS

When was the last time you used excel tables? Do you know how powerful excel tables are? If you have never or not recently used excel tables, it could be because you have not realized how powerful they are in data analysis. By reading below 7 excel table’s secrets,...
7+ WAYS TO LOOKUP NUMBER VALUES

7+ WAYS TO LOOKUP NUMBER VALUES

The ability to lookup number values in excel is a must-have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like...