True/False

[Guest]

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.

 

[Guest]

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.

 

[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

 

[Guest]

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

Many thanks