Archive for the ‘Case sensitive’ Category
My definition of unique values are values that exist only once in a cell range. The image below shows you […]
Comments(0) Filed in categories: Case sensitive, Excel, Unique values
In this post I am going to describe how to filter duplicate and unique distinct values from a really large […]
Comments(4) Filed in categories: Case sensitive, Duplicate values, Excel, Unique distinct values
How to use udf Select cell range D3:D10 Type =CSUnique(B3:B10) in formula bar. Press and hold CTRL + SHIFT Press […]
Comments(1) Filed in categories: Case sensitive, Excel, Unique distinct values
Array formula in D4: =INDEX($A$1:$A$7, SMALL(IF(EXACT($A$1:$A$7, $E$1), ROW($A$1:$A$7), ""), ROW(A1))) + CTRL + SHIFT + ENTER. Copy cell D4 and […]
Comments(0) Filed in categories: Case sensitive, Excel, VLOOKUP and return multiple values
