Prev: percentage of green cells in list
Next: Macro for summarizing multiple sheets
From: Eduardo on 19 Feb 2010 08:09
Hi,
Take a look at Debra web, she has an excellent explanation and great video
about Pivot tables

http://www.contextures.com/Pubn01.html

In the above link go to the end there you will see more link to other pages

http://www.contextures.com/Pubn03.html

if this helps please click yes thanks

"RobFJ" wrote:

> I've four columns of data over three hundred rows :
>
> Gender - M or F
> Grade - 1 to 15
> Company - Five text names
> Salary - Integer figure
>
> I want to be able to create tables where, by company, I can calculate the
> average salaries of men and women by grade.
>
> I know it probably is a pivot table but can't get the steps right to get to
> where I want.
>
> Can SKS help with the rough pivot table steps or a generic formula that I
> could customise.
>
> (The four columns of data are each range-named.)
>
> Thanks
>
> .
>
 | 
Pages: 1
Prev: percentage of green cells in list
Next: Macro for summarizing multiple sheets