LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Summing data on duplicate records?

I have a worksheet that has the following column headers:
Organization
Project#
Cost
Cost Center
Month Posted

where each row lists the cost a project from a specific organization has
charged to a particular cost center (a chargeback data set if you will).

I would like the cost centers listed on the lefthand side and then, based on
a drop down selection of organization, summarize by month (listed across the
top) the charges made to each cost center.
 
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
duplicate records Zack Excel Discussion (Misc queries) 1 August 22nd 08 08:24 PM
Summing up Unique Records Isabelle Excel Discussion (Misc queries) 2 June 11th 08 01:30 PM
duplicate records rcarlo Excel Discussion (Misc queries) 1 December 11th 07 11:30 PM
How do I merge 2 data bases in Excel avoiding duplicate records? Harrison Excel Discussion (Misc queries) 1 July 28th 06 08:45 PM
Summing the # of records matt330 New Users to Excel 1 October 19th 05 04:15 PM


All times are GMT +1. The time now is 10:35 AM.

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

About Us

"It's about Microsoft Excel"