Re: Last 5 rows of data

[#1]

Thanks treseco, that did it .

Is there any way to replicate that logic using rangeav if i was to find an average for the past 5 rows like in the excel example attached.

Regards

Rahul