merging lines

C

Carrie

I would like to know if there is a way to to merge lines in excel, sum a
number, then do the same for the next person-- for instance:

ID name start end salary
1235 John doe 1/1/05 1/31/05 100
1235 john doe 2/1/28 2/28/05 200

(summary) 1235 john doe 1/1/05 2/28/05 300
 
J

JulieD

Hi Carrie

one option, sort your data (using data / sort) by ID and then choose data /
subtotals - at each change in ID, SUM, SALARY - you've then got little
numbers on the left of the screen where you can display the data in
different ways - to get rid of the subtotals you can choose data / subtotals
/ remove all

another option is to use a pivot table
check out www.contextures.com/tiptech.html for deails

Cheers
JulieD
 
R

Re: Pivot Table/Query

Carrie I have almost the exact same situaton. Were you able to figure it out
using a Pivot Table? If so, please let me kno whow. I know the subtotaling
thing will work, but I have a massive spreadsheet with about 30 columns & a
pivot table would be so much easier to read.
 
Top