Folks, I am setting up some dynamic charts using the offset function and for some strange reason it is not picking the last 13 columns. The formula is: = OFFSET(‘Reporting’!$C$5,0,COUNTA(‘Reporting’!$5:$5)-13,1,13) I would have thought that COUNTA function would work, but it is not. What am I doing wrong? Many thanks for your help, Mzungu
Are you kidding?
notenoughtheta Wrote: ------------------------------------------------------- > Are you kidding? I lol’ed