Hi,

To return the last 6 values put this in a cell and array enter with
CTRL+Shift+Enter and then drag 5 columns to the right. You can then chart the
5 extracted numbers.

=OFFSET(INDEX(2:2,,COUNT($2:$2)),,ROW(A1)-COLUMN(A1),1,100)

Mike

"brumanchu" wrote:

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