View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB[_3_] RB[_3_] is offline
external usenet poster
 
Posts: 2
Default 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