My Data comprises a number of rows, and 2 columns. The data grows down the page over time. The First column contains a single Text character and the second column contains a date. The dates are not necessarily in order. I want to search down column 1 to find the row with the LAST "S" (noting there may be several rows with an S in col 1), and return the Date which is in that row in column 2.
Many thanks in advance.
Bookmarks