Hello Chaos is back... It's Been awhile. Looking for best approach.
I have Specific Names (Job Titles) that are listed in 1st column one.
There are adjacent columns providing Names of 20 Locations (Site 1-20) with # of positions, and Annual Salary of position for dept within site (so they are 3 dept listed in columns associated with each site.
I may have to combined similar Job titles to find out total # of positions and there annual salaries totaled.
Column 1
A2 Admin
A3 Sect
A4 Rec
A5 Maint Worker
A6 Eng
A7 Sales Manager
A8 Food Service Coor
A9 Instructor
etc...
Column 2-19
Dept Z1
# Positions
$$$ Salary Amount
Dept Z2
# Positions
$$$ Salary Amount
Dept Z3
# Positions
$$$ Salary Amount
Dept Z4
# Positions
$$$ Salary Amount
Dept Z5
# Positions
$$$ Salary Amount
Dept Z6
# Positions
$$$ Salary Amount
Column (21-22)
Column 21 Total of Dept Z1, Z3, Z5 (for positions titled A2,A3,A4,A7)
Column 22: The average annual salary which is totals/number of positions. End result needs to be average of a chosen group of positions annual salary.
What would you suggest to be the best method... I have looked at vlookup, hlookup, have never done pivot or array... What method would you suggested and what formula is best suited. Thank you for your assistance...
I have Specific Names (Job Titles) that are listed in 1st column one.
There are adjacent columns providing Names of 20 Locations (Site 1-20) with # of positions, and Annual Salary of position for dept within site (so they are 3 dept listed in columns associated with each site.
I may have to combined similar Job titles to find out total # of positions and there annual salaries totaled.
Column 1
A2 Admin
A3 Sect
A4 Rec
A5 Maint Worker
A6 Eng
A7 Sales Manager
A8 Food Service Coor
A9 Instructor
etc...
Column 2-19
Dept Z1
# Positions
$$$ Salary Amount
Dept Z2
# Positions
$$$ Salary Amount
Dept Z3
# Positions
$$$ Salary Amount
Dept Z4
# Positions
$$$ Salary Amount
Dept Z5
# Positions
$$$ Salary Amount
Dept Z6
# Positions
$$$ Salary Amount
Column (21-22)
Column 21 Total of Dept Z1, Z3, Z5 (for positions titled A2,A3,A4,A7)
Column 22: The average annual salary which is totals/number of positions. End result needs to be average of a chosen group of positions annual salary.
What would you suggest to be the best method... I have looked at vlookup, hlookup, have never done pivot or array... What method would you suggested and what formula is best suited. Thank you for your assistance...
