Hi all, I have a range C2:C51. I would like a formula that tells me if there are any duplicates excluding empty cells or 0.
Note cells C2 to C51 have the following formula in them
C2=Watch!$B$11
C3=Watch!B38
ect
So I'm wanting to check the outcomes of the formulas.
Note cells C2 to C51 have the following formula in them
C2=Watch!$B$11
C3=Watch!B38
ect
So I'm wanting to check the outcomes of the formulas.