Prev: How do I match 3 different workbooks information for similar data?
Next: need help with formula
From: T. Valko on 19 Apr 2010 17:44
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Donna" <donna(a)yahoo.com> wrote in message
news:E94B03AD-D566-403B-800D-73905419B947(a)microsoft.com...
> Worked great, thanks
>
> "T. Valko" wrote:
>
>> One way...
>>
>> Use a helper column to mark the duplicates.
>>
>> Enter this formula in column D and copy down to the end of data:
>>
>> =IF(COUNTIF(C$2:C$20,C2)>1,"DUP","")
>>
>> Then apply AutoFilter and filter on column D = DUP
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Donna" <donna(a)yahoo.com> wrote in message
>> news:463A679D-7786-49D8-A2B4-AE7BCB86F82C(a)microsoft.com...
>> > 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
>> >
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: How do I match 3 different workbooks information for similar data?
Next: need help with formula