poorwallace
Active Member
- Joined
- Mar 8, 2005
- Messages
- 365
Alright...
I've been playing around with using BigNum and I came across this formula that Aladin posted for someone looking for the average of the last 5 values in a column.
=OFFSET($A$1,MATCH(BigNum,A:A)-5,0,5,1)
It works fine. But if I change A$1$ to A$3$ it only takes the average of the last 3 values. I don't understand why this is. Other than that, I understand the formula and think it's quite ingenious...
Any help would be appreciated.
Thanks
Wally
I've been playing around with using BigNum and I came across this formula that Aladin posted for someone looking for the average of the last 5 values in a column.
=OFFSET($A$1,MATCH(BigNum,A:A)-5,0,5,1)
It works fine. But if I change A$1$ to A$3$ it only takes the average of the last 3 values. I don't understand why this is. Other than that, I understand the formula and think it's quite ingenious...
Any help would be appreciated.
Thanks
Wally