Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
identify duplicates and sum corresponding values
Hi there,
I only have 2 columns in my dataset but i have around 40,000 rows so i need something relatively quick and easy! ID's are shown in column A and number of days is shown in column B, there are duplicate ID's in A. I need to sum B according to column A (i.e. for ID: 1 i need to add B1 and B2 to equal 13). Can anyone help me with this? A B 1 5 1 8 2 4 3 6 3 5 3 2 Thanks, -- Amanda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify the cell with Max & Min values | Excel Worksheet Functions | |||
Auto Identify Values | Excel Discussion (Misc queries) | |||
Identify where max values are found | Excel Discussion (Misc queries) | |||
How can I identify the two lowest values in a row? | Excel Worksheet Functions | |||
identify duplicates | Excel Discussion (Misc queries) |