Forum Discussion
Offset
When there are different cells containing numerical data how do I get the data from the latest 5 cells? I think it's offset but how to arrange this? The value of the latest 5 cells should be ...
It is not working for me.
Could you put the formula in the file uploaded in the previous comment?
Thanks
The LET function has only recently been released on the insider's channel for beta testing. Without it, there is a catch in that the INDEX function prevents spilling so the formula needs coercion to work.
played: = MAX( IF( ISNUMBER(scores), round ) )
idx: = 2 * ( played - {4,3,2,1,0} )
Sco: = INDEX( scores, idx-1 )
Con: = INDEX( scores, idx )
= SUM(N(IF(1,Sco)))
= SUM(N(IF(1,Con)))