Lookup data not in a Sample

4 Ways To Lookup Data Not in a List/Sample Using Excel

Crispo Mwangi | 17-Aug-18 | 2 Comments

There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to lookup items not matching a list. For example, below we have a list of mechanics […]

Lookup unique values

2 Ways to Lookup Unique Values in Excel

Crispo Mwangi | 4-Aug-18 | Leave a Comment

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 2 ways to tackle the duplicate data menace and create a dynamic lookup table with unique values. The task is to create a dynamic lookup list of […]