Forum Discussion
Comparing Data from Two Excels - Most Views One & Most Engagements
I have two excel sheets.
One, I've sorted by "most engagements" and the other sorted by "most views."
Each sheet has the same emails for each employee.
I'd like to compare data from the two sheets together and find out from the individuals with the "most views" who from that list has the "most engagements."
Could folks recommend the best way.
I assume what way could be combine data using the pivot table with the emails as the common denominator and match engagements to the "views" list by email.
Then sort first by "views" then "engagements".
If that's the best way, could someone share the easy-to-follow instructions for pivot tables?
Thanks
15 Replies
- You could do an xlookup here, using the employee email, on the Most Views sheet, look up the number of engagements for that same email on your engagements sheet. This will list out engagements along side views so you can have views and engagements side by side. Then use a "Custom sort" with two levels, to sort first by views then engagements.
Let me know if you need a more in depth explanation!I'll use two lists side by side so it'll be easier to show, but this will work across sheets too. So I would combine your two data lists using a look up, starting with this (your two sheets):
xlookup in column C =+XLOOKUP(A33,E:E,F:F,"") this transfers engagements from sheet 2, no matter what the order, and matches to the correct person or email in your case.
Select your data on sheet one and custom Sort:
Then add two sort by levels, first by views largest to smallest, then engagements largest to smallest:
