Archive for EXACT function
The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The […]
The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]
How to extract a case sensitive unique list from a column
My definition of unique values are values that exist only once in a cell range. The image below shows you […]
Case sensitive lookup and return multiple values
The array formula in cell F5 returns adjacent values from column C where values in column B matches the search […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
5 easy ways to extract unique distinct values
You have quite a few options to choose from if you are looking for a way to create a unique […]
