Archive for Case sensitive
The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]
Filter unique distinct and duplicate values from a large data set in excel 2007
In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]
Filter unique distinct values (case sensitive) [Excel UDF]
The User Defined Function demonstrated in the above picture extracts unique distinct values also considering lower and upper case letters. […]
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 […]
