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 ALTERNATIVES TO NESTED IF FUNCTION

7 ALTERNATIVES TO NESTED IF FUNCTION

IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery.  However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond, you can...