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

Pin It on Pinterest