I'm looking for a recommendation on how to approach this. I've attached an example. I have three sets of data that I am comparing. I need to call out differences from one to the other.
How would I best do this? I think the first step is to identify instances where the data is the same for all three data sets. But here's the thing - the data won't always reside on the same row.
So from a formula standpoint. Could I do something that would say - for example if you've opened the example attachment - if "ID" exists in C:C, and I:I, and O:O, and if the corresponding information in the next columns, so D:D, J:J, P:P matches - mark it as such. If the information matches in only two of the three (D,J,or P), mark as such.
Thanks!
Bookmarks