Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Unique
Hi,
I want to identify unique customer names from column A, AND, sum the respective amounts from Column B, to produce a result similar to that below. Any suggestions please ? A B John 50.00 Peter 11.00 Paul 20.00 Ian 10.00 John 15.00 Ian 20.00 Paul 13.50 RESULT= Ian 30.00 John 65.00 Peter 11.00 Paul 33.50 Regards Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
existing unique value formula help (index(match(countif))) | Excel Worksheet Functions | |||
how do i find unique avg buy prices in multiple group of buys/sell | Excel Worksheet Functions | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
count unique with conditions | Excel Worksheet Functions |