Hello Excel community!
Thank you so much for clicking on my question - I have found this site to be very helpful and informative.
On the attached, you will find four columns of text data. Columns A:B are from one system, and columns D:E are from a different system. I need a quick way to compare the data in columns A:B to the data in column D:E. and then compare the data D:E to A:B.
As you can see, columns A and D are Sales Managers and columns B and E are Sales Reps. I need to be able to specifically "call out" or identify where I have discrepancies between the two.
Can someone help me with a quick and intuitive approach? Thanks!
Bookmarks