copying data from subtotals

[sdelacey]

Good Evening

I'm stuck, can any body help?

I have used the subtotal function count and sum, see below

2649191 1
2649191 1
2649191 4
2649191 Total 6
2649191 Count 3
2649249 1
2649249 2
2649249 Total 3
2649249 Count 2


What I have been tring to do is create two columns on the same spread sheet to look like

Number Total Count
2649191 6 3
2649249 3 2

and to carry if need be

Cheers

Steph

 

[SkipVought]

Steph,

This cam EASILY be accomplished using the PivotTable Wizard.

1) Loose the subtotals and counts

2) Each data column must have a unique Heading.

3) Use Data/PivotTable to create your report

Drag the Number heading to the Row Area
Drag the value heading into the Data Area, right click on it and select Sum of value
Drag the value heading into the Data Area AGAIN, right click on it and select Count of value
Finsh
Drag the Data heading in the resulting PivotTable into the Total Heading

VOLA!


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[sdelacey]

Hi ya Skip

I am well impressed, I have never used a pivot table before and I think I will use this more often. But could you stil help me, I need to have all the information in one row, at the moment it is spread over two rows. eg.

2684558 sum of no 5
count of no 1

can it look like

ITEM SUM of No Count of NO
2684558 5 1

Thank You

Steph

 

[SkipVought]

Drag the Data heading in the resulting PivotTable into the Total Heading

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884