Hello,
I am setting up a spreadsheet to return the last 6 values of a running data
set.

I can get the rightmost value with the lookup function, but if I want to
constantly return only the last six values to trend on a chart, how can I
accomplish that?

Thanks for the help,
bruce