Log In
Register
Home
New Member
December 1, 2021
Offline
Hello
I have a file with data from Google Analytics which I would like to compare with the data from my database and I was wundering which formula to use...?
Attached an Excel file, there are 2 sheets (from 2 different sources) In the sheet: "gegevensset1", I would like to compare the "VacatureID" with the data in sheet: "Blad1", however the column VacatureID is a vacancy ID and multiple persons can apply on the same vacancy, therefor there are columns with date and time to compare with the other sheet... (hope you can still follow)
I would like to see who applied on wich vacancy ID, but I can't find the right formula to do so, because the formule has to take multiple criteria into acount...
Thx in advance to help me out here 😉
Trusted Members
February 13, 2021
Offline
I would probably do a pivot table. I believe with Power Query you can set up relationships between the data on both sheets. Unfortunately I don't know much about it as I haven't had the opportunity to use it myself, but if you follow this link, it gives a general overview of the program. Hope this gets you started at least.
Trusted Members
October 18, 2018
Online
With Power Query, I have done a full outer join of the two files. Not exactly sure what you are looking for here but this may be helpful
1 Guest(s)
