Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

Returning the last value based on a condition seems like a difficult problem to solve unless you try one of these easy-to-implement solutions.