I need a formula to identify the most 'recent' appearance of a string in a data set.
The data is customer codes (they are generally six character alpha-numerics, but that doesn't likely matter). The codes represent the last time that a customer had an interaction with the business.
The data is laid out in the worksheet thus:
Dates across the top, with customer codes underneath the date (with a single spacer row).
The customer codes are not sorted, and even if they were, a given code would not necessarily appear on the same row under different dates, and the depth (number of rows) of codes under a date can vary from date to date.
What formula can I use to identify the most recent date that a given code appears under?
I would strongly prefer a formula using native functions rather than using VBA or a UDF if possible.