Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
How to display excel's grouping data in HTML??? jmgoh9915 Excel Discussion (Misc queries) 0 June 13th 06 08:54 AM
Pull data from another sheet based on certain criteria steve_sr2 Excel Discussion (Misc queries) 1 February 23rd 06 10:08 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"