Identify cells

[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

 

[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