| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT DUPLICATES
I am having issues with duplicating lines of info i am currently using a
SUMPRODUCT and and INDEX function but can n ot seem to get it to work acurately. Current Data EQ# Cost Code Hours 1 2.2.200 1 3.2.710 4 1 3.4.700 3 1 3.4.710 5 1 3.4.710 6 1 3.4.710 5 1 3.4.710 2 1 3.4.710 2 1 3.4.710 2 1 3.4.710 8 1 3.4.710 7 1 3.4.710 8 1 3.4.710 7 1 3.4.710 6 1 3.4.710 4 1 3.4.710 6 1 5.2.100 5 I would like to go to a second sheet put in 1 eq number and have it populate the cost codes and sum of hours within those cost codes without duplicating cost codes and hours. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | 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 Discussion (Misc queries) | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
Threaded Mode
