LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Consolidating and totaling rows into single row

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
consolidating data in a row based on a single identifier John Excel Discussion (Misc queries) 1 December 9th 09 01:53 AM
Consolidating Rows Cow Girl Excel Discussion (Misc queries) 0 July 22nd 09 04:25 PM
consolidating or totaling info M.GONZALEZ[_2_] Excel Worksheet Functions 2 June 4th 09 02:30 AM
Consolidating Macros Into Single Workbook [email protected] Excel Discussion (Misc queries) 2 May 4th 07 07:58 PM
Consolidating Rows Jason Excel Discussion (Misc queries) 2 July 26th 06 02:37 AM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"