I'm having an excel column range of Text+Numbers (including blank cells) something like:
First what I need is to Count total number of similar values and I'm stuck with the logic for counting total unique "similar" values... example "GE" & "GD" separately.
How to count total number of unique "GE" values in the list? I thought =COUNTIF(B:B,"*GE*")should work but it does not. It gives total count of "GE" (8 total) but I need to find unique count.
Example GE001 & GE002 should be considered as 2 values and shown as 2 in total.
Kindly help
Code:
00EGB00-GE001
00EGB00-GE001
00EGB00-GE001
00EGB00-GE001
00EGB00-GE002
00EGB00-GE002
00EGB00-GE002
00EGB00-GE002
00EGD20-GD101
How to count total number of unique "GE" values in the list? I thought =COUNTIF(B:B,"*GE*")should work but it does not. It gives total count of "GE" (8 total) but I need to find unique count.
Example GE001 & GE002 should be considered as 2 values and shown as 2 in total.
Kindly help