Hi Donna, try this.

In E2:

=INDEX($C$2:$C$100,MATCH(TRUE,
INDEX(COUNTIF($C$2:$C$100,$C$2:$C$100)1,),0))

in E3:

=INDEX($C$2:$C$100,MATCH(1,
INDEX((COUNTIF(E$2:$E2,$C$2:$C$100)=0)*
(COUNTIF($C$2:$C$100,$C$2:$C$100)1),),0))

copy E3 down as far as required.

HTH
Steve.



"Donna" wrote in message
...
If you could help me with this it would be greatly appreciated.
Column A Has client codes
Column B Has client names
Column C Has client addresses
The same address may be used for multiple client codes. I am only
looking
for duplicate addresses. What I would like to end up with in my report is
only the lines that have addresses that are listed more than once. If
an
address is only listed once , I do not want it to show on my report.
Thanks