Thread: Grouping data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MaR MaR is offline
external usenet poster
 
Posts: 17
Default Grouping data

I'm using excel 2003
What i need to do is to group data. For example i have table
1|3
2|5
1|2
3|6
2|2

What i need to get is:
1|5 (sum 1,3 row column B (3+2))
2|7 (sum 2,5 row column B (5+2))
3|6

Any ideas?