Hi All,
I am trying to do something very basic, however, i am unable to.
I am trying to create a formula from a PIVOT table and then copying it down to all cells for that column, however, i keep getting the same formula in all cells in the column.
Is this possible and how am i able to do this, please see my table attached.
Thanks.
Last edited by a.hussain; 02-15-2012 at 05:24 AM.
You can just type the cell references in rather than clicking
As you can see there are over 200 cells in a column and this would mean that i wold have to change this for each and every cell, right?
nope, only the row then you can drag down
Works perfect, Thanks Kyle
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks