Hi there, in my example attached I have a list of data in Column A.
What I want Cell K1 to do is find and return the first word within brackets from this list which is not IRE or AW.
So in this example it is AUS. If Row 8 was missing it would be NZ.
Thanks in advance for any assistance
Bookmarks