|
|
#1
03-31-2012, 02:10 AM
|
|||
|
|||
Summary on page
I have prepared a salary sheet of employees. I want to take department wise print of on separate page. It is easy to do through filter. However, I also want summary of department wise salary on last page only. How can I accomplish this?
|
|
#2
04-09-2012, 04:57 AM
|
||||
|
||||
|
Without knowing the data structure, no one can offer much advice.
Depending on what the data structure is, you may be able to summarize each department's data using SUMPRODUCT, a LOOKUP, an INDEX/MATCH combination, or an array formula of some kind - or any combiation of these.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| project summary | ketanco | Project | 1 | 01-02-2012 02:35 PM |
| Task and Summary Durations | JR_12 | Project | 0 | 10-15-2011 05:07 PM |
 Find summary level
|
AndreT | Project | 2 | 08-05-2011 09:56 PM |
|
Summary width
|
marcofano | Word | 1 | 04-29-2010 04:32 AM |
| Summary Page | Greenr81 | Word | 0 | 01-26-2010 12:08 PM |
Windows 7 32bit 
Office 2007
Linear Mode
