EXACT function

Excel » Functions » Text » EXACT function »

How to use the EXACT function

The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The […]

INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

Match two columns

This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]

How to extract a case sensitive unique list from a column

This article demonstrates a formula that extracts unique values from a column also considering upper and lower characters (case sensitive). […]

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 […]

5 easy ways to VLOOKUP and return multiple values

This post explains how to lookup a value and return multiple values. No array formula required.

Count unique distinct values

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

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]