Having Excel print a cell location

[Eliezer]

Hello... I'm using the duplicate finding method suggested
by Frank of:

=IF(SUMIF($E$1:$E$999,E1)>1,"Duplicate", "OK")

The thing I'm trying to do now is have Excel reference the
cells that are duplicate. Is there any way that Excel can
print out "Duplicate, C2 C534"? Thanks.

 

[Jonathan Rynd]

Hello... I'm using the duplicate finding method suggested
by Frank of:

=IF(SUMIF($E$1:$E$999,E1)>1,"Duplicate", "OK")

The thing I'm trying to do now is have Excel reference the
cells that are duplicate. Is there any way that Excel can
print out "Duplicate, C2 C534"?

Try this:
in F1 put
=MATCH(E1,E2:$E$999,0)+ROW()
in G1 put
=IF(ISNA(F1),"OK","Duplicate, "&ADDRESS(ROW(E1),COLUMN(E1),4)&
" "&ADDRESS(F1,COLUMN(E1),4))

It can be done in one cell (substitute in the contents of F1 for the F1),
but it's a longer formula and additional work for Excel.

If your area doesn't start in row 1, you have to adjust things
accordingly.