View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default Extract value from Specific Cell

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