Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Excel 2003 spreadsheet with Position Title, Location, Pay Plan,
Position Series, Position Grade, and FTEs. I want to organize this data by Position Title, then Location, then Grade, and finally FTEs. For example, I have multiple rows of Human Resources Specialist in different locations, in different grades each with a FTE of 1. I'd like to consolidate each row of Human Resources Specialist in the same location in the same grade and have the row display the total number of FTEs for that title in that grade at that location. Thanks in advance for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
consolidating data in a row based on a single identifier | Excel Discussion (Misc queries) | |||
Consolidating Rows | Excel Discussion (Misc queries) | |||
consolidating or totaling info | Excel Worksheet Functions | |||
Consolidating Macros Into Single Workbook | Excel Discussion (Misc queries) | |||
Consolidating Rows | Excel Discussion (Misc queries) |