Hello,What solution are you looking for?
It's funny I was just looking at offset, summing every n'th row on excel jet. Your fomula returned a Ref# but it was on the money none the less. BYROW(A12#,LAMBDA(X,OFFSET(X,1,,1,)-X)Your DROP formula is the one I was going to give you, but since that is not what you want, does this do what you want?
=DROP(SCAN(,A2#,LAMBDA(a,x,OFFSET(x,-1,)-x)),1)
Read Message #5 that the OP posted.=DROP(A2#, 1) - DROP(A2#, -1)