gbarclay2001
New Member
- Joined
- Mar 17, 2002
- Messages
- 46
Hi all,
after looking at a web page Dave Hawley kindly directed me to after my last post (www.ozgrid.com/Excel/DynamicRanges.htm), I'm still unable to solve my problem.
I have a pivot table on which I need to use the OFFSET command to find the total(bottom) row of a column in the table. The amount of rows in the pivot table is changeable and that's why I can't set a static reference to it. Also, not all of the rows will contain data so I basically have to find the last cell containg a number in a column.
My last (poor) effort looks like this:
=OFFSET('By Value'!$C$5,0,0,,MATCH("*",'By Value'!$C:$C,0))
This is just giving me the value of C5 but the total (and last figure in the column) is cell C12.
Any ideas what I'm doing wrong?
Greg
after looking at a web page Dave Hawley kindly directed me to after my last post (www.ozgrid.com/Excel/DynamicRanges.htm), I'm still unable to solve my problem.
I have a pivot table on which I need to use the OFFSET command to find the total(bottom) row of a column in the table. The amount of rows in the pivot table is changeable and that's why I can't set a static reference to it. Also, not all of the rows will contain data so I basically have to find the last cell containg a number in a column.
My last (poor) effort looks like this:
=OFFSET('By Value'!$C$5,0,0,,MATCH("*",'By Value'!$C:$C,0))
This is just giving me the value of C5 but the total (and last figure in the column) is cell C12.
Any ideas what I'm doing wrong?
Greg