Forum Discussion
Are two cells the same if the order is different in excel
If the order does not matter, what formula should I use to prove these are all same
I'd use a helper row. Let's say that your values are in D4, E4, etc.
Enter the following formula in D5, then fill to the right:
=TEXTJOIN(";", TRUE, SORT(TEXTSPLIT(D4, ";"), , , TRUE))
You can then check whether D5 = E5 etc.
Remark: if you use comma as decimal separator, use ; instead of , in the formula:
=TEXTJOIN(";"; TRUE; SORT(TEXTSPLIT(D4; ";"); ; ; TRUE))