VBA code required

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

Hi
I have a very long list(over 18000 entries) Name/address/phone number etxc
From time to time I must add fresh data. The list is then sorted on PHONE
number
I would like VBA code to seach the entire list. Should any duplicate phone
numbers be found I want BOTH lines containing the duplicate numbers to be
removed.

Can anyone help with this
Thanks
 
I assume that the data is in separate columns?

You could add a helper column to count duplicates, and then use autofilter
to highlight the rows meeting the test, and then delete the visible rows.

The formula could me

=COUNTIF(C:C,C1)>1

and filter on True

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top