Report duplicate rows

[matthew.clegg]

What I have is a sheet with duplicate URL’s in a column and I want to
know what rows the duplicates appear in.

For example:

Row URL

1 www.aaaa.com
2 www.xxxx.com
3 www.aaaa.com
4 www.aaaa.com
5 www.xxxx.com
6 www.ffff.com

What I want to get is:

Row URL Duplicate column rows

1 www.aaaa.com 1,3,4
2 www.xxxx.com 2,5
3 www.aaaa.com 1,3,4
4 www.aaaa.com 1,3,4
5 www.xxxx.com 2,5
6 www.ffff.com 6

Can anyone help?
Cheers
Matt

 

[Teethless mama]

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

....then try this formula

=SUBSTITUTE(TRIM(MCONCAT(IF($A$1:$A$6=A1,ROW($A$1:$A$6),"")&" "))," ",",")

ctrl+shift+enter, not just enter

 

[matthew.clegg]

Download and install the free add-in Morefunc.xll from:http://xcell05.free..fr/english/

...then try this formula

=SUBSTITUTE(TRIM(MCONCAT(IF($A$1:$A$6=A1,ROW($A$1:$A$6),"")&" "))," ",",")

ctrl+shift+enter, not just enter












- Show quoted text -

That's great. For work though I can't get that download. Is there a
solution without a download?