Comparing text strings in Excel
Hey y'all! Would anyone please assist with this issue I've run into? Is it possible to compare text strings in two different cells within? Pretty much I want Excel to compare text strings in two separate columns and check if the values match up - think strings like "Timmy, Bob, John" and in the other it may have the same names, but in a different order like "Bob, John, Timmy."
Another idea I had was potentially creating some code or maybe there's an Excel function counting the letters in a text string and if they match then output "Yes." Open to any suggestions. TIA!