| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum the "Bar Tabs"
Hi All,
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 |
Threaded Mode
