I am trying to identify unique instances of a match condition which includes partial matches.
HOSTABC
HOSTABC
HOSTABC.domain.com
HOSTABC.domain.com
I am trying to count unique instances of a match condition. I have a formula that does this as long as the cells are an EXACT match:
=(countif($F$2:$F2,$F2$”*”)=1)+0
This formula leaves a “1” for the first instance of the match, and a “0” for all other instances of the match. My problem is that in my example row1 and 2 are BOTH an EXACT match to each other, AND a partial match to rows 3 and 4.
My current formula retus results like this:
HOSTABC 1
HOSTABC 0
HOSTABC.domain.com 1
HOSTABC.domain.com 0
I would like to see row1 with a 1 and all of the other rows in this example with a 0 Any ideas?
برچسب:
نویسنده: استخدام کار