View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephen Rainey Stephen Rainey is offline
external usenet poster
 
Posts: 4
Default 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