Just wondering if I can adapt the formula for counting unique entries
=SUM(N(FREQUENCY(A1:A10,A1:A10)0))
to be able to count the unique entries only if there is a yes in the column
to its left.


"areezm" wrote:

I have two columns, one with numbers and another with yes or no. In the
number column I will have 5 digit numbers that may repeat 2 to three times in
that column and along side in the other column it will say either yes or no.
For any particular number it will only say yes or no, it wont be yes in one
row and no in another. This information gets uplinked from another sheet and
hence is that way. heres a sample

Warranty W.O.
YES 66888
YES 66888
NO 67471
NO 67471
YES 66992
YES 66992
YES 66992
YES 66948
YES 66948
NO 66945

Now what I need to do is count the number of W.O's that were waranty and
which were not, without couting twice or thrice for the same W.O. So in this
example it would need to be a small table like this

Warranty Yes NO
Number of WO's 3 2

would really appreciate any help. Thanks