Hello everyone!
I'm hoping you can help me with this.
Problem:
In Column A I have multiple strings, for example:
1. 20D Fun 0L
2. 10D Fun 0L
3. 0L Fun 20D
As you can see, 1. and 2. have the same information.
Solution:
Ideally I would like the formula to search Column A and find cells which have 3 matching strings. In Column B, the result should output the matching cell. For example, in the data I presented, the result for A1. would be A3.
I appreciate any help.
Bookmarks