using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

		Microsoft Office Forums > Microsoft Excel > Excel
using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

FAQ

Thread Tools

Display Modes

12-21-2016, 09:20 AM

jfeinstein jfeinstein is offline

Windows 7 32bit using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

Office 2010 32bit

Novice

Join Date: Dec 2016

Posts: 5

Thanks for your reply. The row that is not calculating correctly is row 14 in the sheet Hours by Title Q1. In column C, for example, it should no longer use the data in cells B6-B12 (multiplied by the values in A6-A12), but should instead be using values in C6-C12, multiplied by the values in A6-A12.

Tags

formulas, pivot tables

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table - Copy Rows	theexpat	Excel Programming	0	02-26-2016 08:14 AM
Data not showing in Pivot Table	MichelPierre	Excel	2	01-26-2016 10:51 AM
Pivot Table Duplicate Data	cnw	Excel	0	08-31-2012 08:24 AM
Keeping the top row constant in Excel	MSmand	Excel	2	07-13-2011 01:14 PM
Using subtotals in Pivot table formulas	ninfanger	Excel	3	10-23-2010 12:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 PM.