Having Excel print a cell location

  • Thread starter Thread starter Eliezer
  • Start date Start date
E

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.
 
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"?
Click to expand...

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.
 
Back
Top