On May 28, 11:36*am, Teethless mama
wrote:
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



" wrote:
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- Hide quoted text -

- Show quoted text -

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