10 Replies Latest reply on Dec 17, 2018 3:15 AM by Ciara Brennan

    Display the value from the last row that has a value

    Meghan Tighe


      I have attached a workbook that contains a "Last Seen" worksheet. I have a series of dates, but only a location populated on certain rows. I need a calculated field that will display the value in the location field from the last date that a location was logged. Using my example, I need my field to display "Italy" for every row between 10/1 - 10/11, and then it should switch to Spain. I've been tinkering with LOOKUP(), WINDOW_MAX, and other table calculations but I can't seem to get this, even though it seems fairly simple. Thanks for your help.