Hi, I'm trying to find a way to compare two different cells with that contain codes, but they may be in different order. A simple example is below. Obviously, A1=B1 will generally return FALSE, unless the codes just happen to be in the same order. I'm looking for a way to have the formula (or user defined function, if that's what it would take) check to see if all of the codes in A1 are also in B1. Thanks for any insight.
Cell A1: 10,4114,4118,4115
Cell B1: 4114,4115,4118,10
Bookmarks