| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates without Sorting
I have a file that has quantity and codes. Each code has an amount, but they
are different amounts and the code duplicates many times. I need a formula that totals each group of codes. The codes cannot be sorted so they are all together they must be separate to keep lots together. C = The results I would like to have. A B C 10 AR5 10 25 AC6 25 AC6 50 15 AR5 25 AR5 25 AR5 65 12 AC6 10 AC6 22 22 XR6 Any help would be appreciated!! Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Finding Duplicates in a Column (Without Sorting) | Excel Discussion (Misc queries) | |||
| Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
| When sorting, how would I omit duplicates? | New Users to Excel | |||
Threaded Mode
