Hello,
I am trying to update a giant list of clients for 2019 (thousands of rows, so I can't do this manually).
The 2019 list represents a list of clients, their ID number, the manager and all of their associates.
The 2018 list represents a list of clients, their ID number, the manager and ONLY their main associate.
I need to highlight or somehow isolate instances of changed managers, then do the same for changed associates. Here's the issue: It's not Apples-to-Apples, because some clients have left or changed and many clients swapped managers and/or associates. The old list only includes the main associate, but the new list sometimes has duplicate rows for clients with multiple associates.
I'm open to your ideas for efficiency.
Thank you. See two example sheets on the attached.
Bookmarks