Hi all,
Hoping you can help with some advice.
I basically have a long list of titles of letters with the sender and receiver. I would like to be able to instantly pull all the names in the list of cells that appear before the letter 'to' so I can then look at the frequency with which these names appear.
I'm hoping this may be a simple piece of code?
Thank you very much in advance from a beginner!
Bookmarks