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?