Hi, trying to figure out the following.
Column A has multiple instances of the same name.
column B may have 'after' or 'prior'
I want a result where the same name appears in column A but only if in column B that name has both 'after' AND 'prior' in seperate cells for the same name in column A.
Bookmarks