Return multiple cell addresses

[Bob]

Hello Group,

I have a column of data that can contain both text and
numbers. Some values may be duplicated throughout the
column. I can extract all the duplicated values using a
formula. What I would like to do in an adjacent column to
the extracted duplicates is show the cell address for that
duplicate value. I can do this easily for the first
instance of a duplicate but can not figure out how to get
the address for the nth instance. Example:

A B C
1 10 10 $A$1
2 13 11 $A$3
3 11 10 $A$4
4 10 11 $A$6
5 15 10 $A$8
6 11
7 12
8 10
9 17

I know this is pretty complicated but does anyone have a
solution? I would like a formula please, no vba.

Thanks
Bob P.

 

[Bob]

-----Original Message-----
Hello Group,

I have a column of data that can contain both text and
numbers. Some values may be duplicated throughout the
column. I can extract all the duplicated values using a
formula. What I would like to do in an adjacent column to
the extracted duplicates is show the cell address for that
duplicate value. I can do this easily for the first
instance of a duplicate but can not figure out how to get
the address for the nth instance. Example:

A B C
1 10 10 $A$1
2 13 11 $A$3
3 11 10 $A$4
4 10 11 $A$6
5 15 10 $A$8
6 11
7 12
8 10
9 17

I know this is pretty complicated but does anyone have a
solution? I would like a formula please, no vba.

Thanks
Bob P.
.

OK, never mind, I figured it out and it wasn't that
complicated!!!!

=ADDRESS(SMALL(IF(COUNTIF(A$1:A$2150,A$1:A$2150)>1,ROW
(A$1:A$2150)),ROW(1:1)),1)