Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
Finding Non-Duplicates | Excel Worksheet Functions | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
help...finding duplicates | Excel Worksheet Functions | |||
Finding duplicates | Excel Worksheet Functions |