sorting data

  • Thread starter Thread starter powelly
  • Start date Start date
P

powelly

Sorry if this has been asked before, but ive searched to no avail, as I
dont really know what to call the question.

i have the following

A B
4 2
1 5
2 3
1 6
4 3


Can I automate the sorting of this data so that for each value in
column A the Values in Column B are totaled, ie it becomes

A B
1 11
2 3
4 5


Thanks

Andy
 
You could either sort your data by column A and then Data|subtotals or you could
add headers and do Data|pivottable.
 
Back
Top