I feel like this should be a simple solution that I'm missing, but I have a spreadsheet with string values in column A. In column B, I have timestamps reflecting the last time a corresponding value in A was updated.
i.e.
Alpha 01/01/1900 14:00
Beta 01/01/1900 14:30
Gamma 01/01/1900 14:15
Delta 01/01/1900 14:10
I need to return the most recently updated string value; in this case, Beta. How can this be accomplished without using the ROW function? (I just built a solution using ROW only to find that the application reading the xls as a datasource doesn't support ROW.
I eagerly await your breadcrumbs.
Thanks
Bookmarks