I am working on a file where i have to make sure that two columns have the same data. The issue is that the data is not arranged in the same order in both columns i.e (see below). What formula/s can i use to show that the two cells hold similar information although arranged different? Kindly Assist. Thanks in Advance.
|Column A||Column B|
|Item A;Item B;Item C||Item B;Item C;Item A|