خرید بک لینک

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?

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 1 ارديبهشت 1395 ساعت: 18:42

صفحه بندی