by Crispo Mwangi | Aug 17, 2018 | BASIC EXCEL, INTERMEDIATE EXCEL
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 look up items not matching a list. For example, below we...
by Crispo Mwangi | Aug 4, 2018 | ADVANCED EXCEL, INTERMEDIATE 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...
Recent Comments