Hi all,

I am struggling with the following problem:

I want to use the following formula:
=OFFSET('Sheet1 (1)'!$C$2;1;0;COUNT('Sheet1 (1)'!$C$3:$C$2008);1)

very easy but this doesnt work. Why, because C2 is a field of a Pivottable
and apparently Excell doest see this as a reference cell.

any ideas how to solve this?

Best regards
Kenny