Identify cells

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I use the formulae

=IF(COUNTIF($B$1:B4;B4)>1;"Exist in row " & MATCH
(B4;$B$1:B4;0);"")

and

=IF(COUNTIF($B$1:B4;B4)>1;"Exist in cell " &ADDRESS(MATCH
(B4;$B$1:B4;0);COLUMN(B4);4);"")

(Thanks to Leo Heuser and Peo Sjoblom!)

to return identification of the first position of repeated
data.

But, I need to identify all cells (not only first).
Is it possible in Excel?

Thanks in advance.
an
 
I would like obtain one expression about all cells where
exist repeated data. For example;

"Exist in cell B1, B5 and Bn".

Is it possible?
Thanks.
an
 
Back
Top