Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Pivot table gives a "Grand Total" of all rows at the end of row. Each time I
run a Pivot Table, the Grand Total Column is changing from column to column. Some time the Grand Total can be find in col "O", "P", "Q" or "R" due to what is being fetched. What type of formula can be build where it can look the Grand total column and link it to the Grand totals of row by row? For Example, if a Grand total is on col "P", Row #2, Col "P" to be link. If a Grand total is on Col "Q", Row #2, col "Q" to be link. Thanks in advance for your help. Dinesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |