Find the last value of a matching row above in Google Spreadsheets
I have a table of items that tracks the price over time. When I add a new row to the table, and the item name already exists within the table, I would like to retrieve the most recent “new price”, and store it in the “prev price” column. Item Date Prev Price New Price apple … Read more