Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you both for your help! Both solutions work just fine!
-Dave "Lori" wrote: On a new sheet, try Data Consolidate, select the table reference with the options "Sum" and labels in "Left Column" then click OK. On 6 Jun, 08:45, Dave wrote: Hi again! I have a list which contains duplicates and values attached to every entry. Like this: col a col b 0 5 0 11 1 7 2 5 ... And I would like to make the list look like this: col a col b 0 16 1 12 ... So, how to do this? Please I need your help! -Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to combine 2 workbook data bases and remove duplicates | Excel Discussion (Misc queries) | |||
check for duplicates, then sum unique values | Excel Discussion (Misc queries) | |||
Count Unique Values In A Filtered Row with Duplicates | Excel Discussion (Misc queries) | |||
Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) |