Hi All,
Hope everyone's having a nice Wednesday morning. I am having trouble comparing two lists of data. They each have the same (or very similar names) but have different values. They're two sets of data from two different quarters, and I need to get the names and changed values side by side so I can calculate the differences. Unfortunately, I cannot sift through thousands of individuals and all the changes that occurred. I'm having trouble devising a formula to do this.
I've attached a screenshot. What I need to have happen is have John Smith and his value in the second group match up on the same row with the John Smith in the first set so on and so forth (but for about 5000 individuals). I really hope this is doable. Thanks in advance!
Bookmarks