True/False

S

SCOOBYDOO

Hiya, I have dates of birth in cols F,J, N, R, V, Z, AD, AH, AL & AP cells
2:2585 and I need to know if there are any duplicates in the colums,
excluding any blank cells.

Many thanks in advance for your help.
 
S

SCOOBYDOO

SCOOBYDOO said:
Hiya, I have dates of birth in cols F,J, N, R, V, Z, AD, AH, AL & AP cells
2:2585 and I need to know if there are any duplicates in the colums,
excluding any blank cells. If poss I would like the output in one column with the cell reference(S) of any duplicates

Many thanks in advance for your help.
Click to expand...
 
T

TJ

use the EXACT function and compare the two cells. You'll see a TRUE where
they equal each other and a FALSE when they don't
 
S

SCOOBYDOO

TJ - do you know what the formula would be please as the following has not
provided sufficient information.

Many thanks
 
Top