LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Sort and Add Columns

Here is my problem. I have a file that is a combination of data from other files. I have that set up just fine. I have names in the first column and data in the second through the eight. What I need to do is find a way to sort by the name as there will be multipe line with the same name in the first column and then add all the data in the other columns together. It looks something like thi

John 3 4 5
John 2 8 5
Mary 3 5 8
Paul 4 6 7
Mary 2 7 9

It needs to condense down so that I would just have three names ie. John, Mary, and Paul and the data in the other columns would be added up for that name ie.

John 5 12 10 1
Mary 5 12 17
Paul 4 6 7

This data is about 1500 rows long so doing it by hand will be a difficult task. If anybody has any ideas it would be geatly appreciated. I know only the basics of recording macros, and I have no idea how else to do it

Thanks

Vinc

 
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
Sort by color: Is there an easy way to sort columns or rows in EX MGP Excel Worksheet Functions 5 August 16th 08 11:28 AM
sort by two columns ends up with wrong sort in 2nd col urbnjckct Excel Discussion (Misc queries) 3 November 2nd 07 01:25 AM
Sort command does not sort some columns? BillyBob New Users to Excel 4 May 11th 06 04:16 PM
How do I sort the data in 8 columns by two of the columns? Sorting Excel Worksheet Functions 1 October 25th 05 03:57 PM
data sort is not including all columns in sort Tracy Excel Discussion (Misc queries) 1 October 4th 05 12:16 AM


All times are GMT +1. The time now is 06:18 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"