If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|