Listing the last value in a range (row/column)
 

We maintain a history of prices charged by vendors for certain items on a
spreadsheet. I would like to specify a cell that displays the latest price
we paid for an item. The items are listed by rows and the week of the year
is displayed as a column heading. Is there a way to list the "latest" price
entered in the row (next column over from "week 52"....)? I do not have
"ownership" of the spreadsheet in question, so I have to make this
"transparent" to the user...if you know what I mean?

Listing the last value in a range (row/column)
 

You could use a formula like:

=LOOKUP(2,1/(A1:A999<""),ROW(A1:A999))
(Make that 999 big enough to extend past the last possible row.)



Tom K wrote:

We maintain a history of prices charged by vendors for certain items on a
spreadsheet. I would like to specify a cell that displays the latest price
we paid for an item. The items are listed by rows and the week of the year
is displayed as a column heading. Is there a way to list the "latest" price
entered in the row (next column over from "week 52"....)? I do not have
"ownership" of the spreadsheet in question, so I have to make this
"transparent" to the user...if you know what I mean?

--

Dave Peterson