| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb SUM OF DUPLICATES
Hi I really need some help with this one - Please ! I have a table with 5 columns. I want to use VB to look for a duplicate in column D, when one (o more) is found, add up the duplicates in column E and delete th unwanted rows. As in example column D column E Prod 1 2 Prod 2 3 Prod 3 56 Prod 3 44 Prod 3 10 Prod 1 33 Prod 1 67 What I would like it to show is column D column E Prod 1 2 Prod 2 3 Prod 3 110 Prod 1 100 Any suggestions -- millero ----------------------------------------------------------------------- milleroy's Profile: http://www.excelforum.com/member.php...fo&userid=2987 View this thread: http://www.excelforum.com/showthread.php?threadid=51178 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicates | Excel Worksheet Functions | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
| Duplicates | Excel Worksheet Functions | |||
| Duplicates | Excel Discussion (Misc queries) | |||
Threaded Mode
