This is a quirky one.
I’ve got a text column I want to compare against itself. It’s all short text.
I would like to search this column and find partial text at the end that matches partial text at the beginning of another cell (and vice versa). So Butterfly matches with Fly fishing. If it could dynamically link these matches, great. I can count from there. If it just counts them, that works too. In this scenario, Butterfly should match with Fly fishing, and Fly fishing should match with Butterfly. If something else ended in “butter”, that’d count towards Butterfly. Make sense? If this is too weird and there is no easy answer, I totally get it. It would just help with a fun way to represent data that I’m toying with. Many thanks.