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 Excel? 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!
Hi MrSocial, any of these threads helpful:
More suggestions...
If those topics were completely useless, don't blame me, blame my programmers...
I don’t know if this can be done in Excel, but you could do it easily using Python. If you look up videos about the library “pandas” you should be able to see pretty quickly how to do something like this. First you’d need to create functions that do what you’re describing to regular strings/lists in Python, and then you could make a program using pandas to apply/use them on an Excel file. If my answer is helpful in any way, you may want to consider posting this somewhere like stack overflow instead or you could probably find similar posts that have already been answered.
Brute force top-of-mind solution but could be recorded as macro.
1. Transpose copy & paste
2. Text to columns
3. Remove spaces
3. Transpose copy & paste back
4. Sort all columns individually A-Z
5. +CONCAT each column
6. Compare these values
Est maiores nihil qui eum. Ipsum aperiam possimus et consequatur cum est nisi. Non repudiandae in architecto qui sed maxime. Illo accusamus totam aliquid optio quia id. Quisquam totam sunt voluptatem quaerat doloribus. Et delectus qui id magni.
Libero qui quibusdam laudantium sed rerum. Voluptas deleniti qui a enim consequuntur nihil sed. Aperiam optio sunt est odio ut voluptatibus excepturi. Enim aut dolorem sed perferendis. Incidunt ut dolorum enim similique quia omnis officiis. Ut qui facilis voluptas fugit similique repellendus officia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...