Filter, where certain line is missing

**qingpool** · 02-15-2011, 09:24 AM

Thank You very much, this works.

I understand the first part - it counts distinctive values, then counts values with specified criteria, then substract the number from total distinctive values.

The second part is an array formula, very advanced for me, but i get the point.

My problem is, i know i have 333 phone numbers without that service. In every result, the formula changes by 2 numbers (in the beginning and in the end). How do i copy that formula so many times with only these values changing :D

Thanks You for Your effort and help

**DonkeyOte** · 02-15-2011, 09:27 AM

Originally Posted by qingpool

My problem is, i know i have 333 phone numbers without that service. In every result, the formula changes by 2 numbers (in the beginning and in the end). How do i copy that formula so many times with only these values changing

I'm afraid I don't really follow the above - could you perhaps post a further sample to illustrate ?