- Joined
- Apr 17, 2012
- Messages
- 1
- Reaction score
- 0
I've tried searching and can't find anything. I need a formula that will compare two columns. I've tried messing with matching formulas and cannot figure this out. I have two fields of data that I always compare to each other to ensure they match, but it's very time consuming. They're not just numbers.
As an example,
Cell A1 "ATG, HPV, MYC" and Cell B1 "HPV, MYC, ATG", this is a match
Cell A2 "T70, R34" and Cell B2 "R34, HSV, T70", not a match
This is my issue, they are not always arranged in order, but they do match and I have to find the ones that do not match. This will go on and on for about 700 or more rows. Does anyone have a solution to make this more efficient?
As an example,
Cell A1 "ATG, HPV, MYC" and Cell B1 "HPV, MYC, ATG", this is a match
Cell A2 "T70, R34" and Cell B2 "R34, HSV, T70", not a match
This is my issue, they are not always arranged in order, but they do match and I have to find the ones that do not match. This will go on and on for about 700 or more rows. Does anyone have a solution to make this more efficient?