Hi All,
So I'm trying to understand offset.
For example if I write =OFFSET(B5,0,2,COUNTA($C$4:$C$1082),1)
And I drag down, it will return the values in C, BUT if I write =OFFSET(B5,0,2,1,3) and try dragging right it wont return anything it just says #Value!
Can someone please explain how offset works? Is it because the range going down (COUNTA) goes all the way to C1082 so if I drag down, Offset will return two rows over from B and even though =OFFSET(B5,0 <-- is 0.
Also I tried to use the same concept to go right --> but when I put =OFFSET(B5,0,2,1,3), the box should be 3 horizontal, 1 vertical. But I get #Value! instead of returning values in the same way (COUNTA) did.
I think I might be not fundamentally understanding Offset, can someone please help?
Also any good combinations to use offset with? I've only used it with average(offset(counta)).
Bookmarks