True/False

[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.

[SCOOBYDOO]

"SCOOBYDOO" wrote:

> 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


"SCOOBYDOO" <SCOOBYDOO@discussions.microsoft.com> wrote in message
news:6F114A10-6936-4AC8-9B1B-EE084E4F154C@microsoft.com...
> 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.

[SCOOBYDOO]

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

Many thanks

"TJ" wrote:

> 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
>
>
> "SCOOBYDOO" <SCOOBYDOO@discussions.microsoft.com> wrote in message
> news:6F114A10-6936-4AC8-9B1B-EE084E4F154C@microsoft.com...
> > 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.
>
>
>