Finding Duplicates
 

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

Finding Duplicates
 

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

"RB" wrote in message
ble.rogers.com...
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