I am using excel to search the body of text to find the the name of the person who most recently replied in an email thread. In some cases the thread may have responses from multiple people. This would mean extracting the most recent name in the text which would appear towards the top.
Currently I've been using IFS() to search the body of text for a predetermined list of names. However, IFS() evaluates the conditionals sequentially and may return a TRUE result for the first match it finds, not necessarily the most recently mentioned.
In the example file, I have included 3 rows of examples with random bodies of HTML text, with the table of names to the right. The 'NAME' column is where the first appearance of any of the names would be returned.
Bookmarks