I IanT Registered User. Local time Today, 16:20 Joined Nov 30, 2001 Messages 191 Feb 14, 2008 #1 Hi I am using this formula to identify data for a pivot. It works fine but it does not identify the last row of the data. Can anyone help! =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),COUNTA(Data!$1:$1))
Hi I am using this formula to identify data for a pivot. It works fine but it does not identify the last row of the data. Can anyone help! =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),COUNTA(Data!$1:$1))
S shades Registered User. Local time Today, 10:20 Joined Mar 25, 2002 Messages 516 Feb 14, 2008 #2 Howdy. Are you using this as a dynamic named range? Or just in the Pivot Wizard? ________ Cheap Glass Pipes Last edited: Feb 16, 2011
Howdy. Are you using this as a dynamic named range? Or just in the Pivot Wizard? ________ Cheap Glass Pipes
