Hi,
I'm struggling with some formula to count unique values in a list but then separated out into categories based on the 1st 3 letters of the the entries in a list.
As an example in column A i have the following:
abc123
abc123
abc123
abc123
def456
def457
def458
def459
ghi123
ghi123
ghi123
ghi123
abc456
abc456
abc456
i would like 3 separate formulas
1 to count unique values that start with "abc" - in the example above result should be 2
1 to count unique values that start with "def" - in the example above result should be 4
1 to count unique values that start with "ghi" - in the example above result should be 1
Any help will be greatly appreciated!
Thanks
Bookmarks