Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Table 1 is as below :
P Q R S Basic 1 3 5 7 HRA 5 7 2 6 Table 2 is as below April May June July Dept P 2 3 4 5 Dept Q 11 12 14 15 I want to determine department wise line itme wiase cost. Please guide me. Eg. Department cost of "P" for April will be Basic (2*1) & Basic will be (2*5=10). Kindly help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Autofiltering multiple tables on a spreadsheet | Excel Worksheet Functions | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) |