Finding Duplicates

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

Hi
Can some one please guide me how find duplicates with in an array. I have a
sheet with part Nos & Price. It will have many duplicate part nos with
different prices. I would like it to find the duplicates display the
duplicates to user & let them select the Cost they want to keep (get rid of
the rest of the duplicates).
Any tips are greatly appreciated.
Thanks in advance

XL 2000 , VBA, Win XP
 
The easiest way would be to sort the array on part number, then you just
compare each successive row to identify the duplicates.

Regards,
Tom Ogilvy
 
Back
Top