If, and, or?

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

 

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/duplicat.htm

 

[Guest]

you can do it with code or if you don't need to do it very often, a brute
force method would be copy your columns with dates to a helper page next to
each column enter F&Row(), J&Row(), etc.
select the columns with the Row() equations copy and paste special values
over the top.
move each set of columns (Dates and cell Reference) so that they are in two
columns total.
Sort both by the date column. (column A?)

in C1 enter 1
in c2 enter
=if(A2=A1),C1+1,1)
and copy down to the end of the data.
insert a row at the top and select column C
use Auto filter on column C and select 1
Delete all of the rows with a 1 in column C
undo auto filter.
this is not one column but it is two columns with all of the duplicates
located.