I need to somehow search nine columns, each containing one text string, some preceded by #. The text strings I collect in a list. So I would need the solution to reference my list of text strings. The correct result would show only the text strings in my list, found in the nine columns. It may seem like a concatenation but not so. A concatenation only bunches up the contents of the nine columns. I want to discriminate for just the text strings in my list. Would appreciate any help. Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
