- Fields A1 and A2 are unique but data in A1 may not be in A2, and visa versa. I want to extract a list where there are differences
- Fields B1 and B2 are not unique. I want to extract a list of differences where Field A1 and Field A2 are the same but the data in Field B1 and B2 no long match.
- Fields C1 and C2 are not unique. I want to extract a list of differences where Field A1 and Field A2 are the same but the data in Field C1 and C2 no long match. Ignore where the data in C1 and C2 match but are in a different order.
- Fields D1 andDC2 are not unique. I want to extract a list of differences where Field A1 and Field A2 are the same but the data in Field D1 and D2 no long match. Ignore where the data in D1 and D2 match but are in a different order.
Item 1 is covered above.
Item 2 formula is
Item 3 formula is
Item 4 formula is
Bookmarks