Case sensitive

Excel » Case sensitive »

INDEX MATCH – Case sensitive

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

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

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