I would add a new column D and concatenate the Code with the address:
(with headers in row 1 and data starting in row 2)
In D2:
=A2&"---"&c2
and drag down the column as far as you need.
Then in E2 (another new column):
=countif(D
,d2)
And drag down.
This will count the number of times the code/address on this row is used in your
data.
Apply Data|Filter|Autofilter to column E.
Show the values that are greater than 1
If you need the info on a new sheet, copy the visible cells to a new sheet.
(I'd just keep them filtered and out of the way.)
Donna wrote:
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
--
Dave Peterson