Forum Discussion

Copper Contributor

Jul 06, 2021

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 t...

Iron Contributor

Jul 07, 2021

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!

Paul_PP
Copper Contributor
Jul 08, 2021
DKoontz Thanks for pointing me in the right direction.

As I'm a newbie with , if you could provide me with a more in-depth explanation, I'd be most grateful.
- DKoontz
  Iron Contributor
  Jul 09, 2021
  Paul_PP
  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:
  - Paul_PP
    Copper Contributor
    Jul 12, 2021
    DKoontz
    
    I'm able to partially set up the LOOKUP, but I can get the formula to go through. I set up the sheet like this, but keep getting a "#NAME?"
    Then I've tried multiple formulaS in C3 for the column C: "=Xlookup(A3,E3:E35,F3:F35)" ; =+LOOKUP(A3,E:E,F:F) . Nothing is working. Can you tell where I'm missing something?

Resources