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?
|