R
RobFJ
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
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