Here's another one:

=IF(SUMPRODUCT(--(MOD(ROW(C7:C200),4)=3),--(C7:C200=C22))=1,"Winner","No
Winner")

Adjust for the real end of range.

Biff

"bikemrh" wrote in message
...
I have used this function on a golf league score sheet:
=IF(SUMPRODUCT(COUNTIF(INDIRECT({"C7","C11","C15", "C19"}),C22))=1,"Winner","No
Winner") to figure out which score for that hole is the lowest and that it
is
not duplicated.

Once I expand the cells to check which are not consecutive I cannot go
past
30 cells. I have about 50 cells to check in a column. How can I accomplish
this in one formula?