Forum Discussion
Solved
QUery related Excel formula
Hello Everyone, Heads Data 2 shows the same information as the original Heads Data 1 however: I have 3 question : 1 -- Two employees are missing. Who are they? 2 -- The job title of o...
Sir, I have tried but not getting correct answer.
Please help.
Please help.
What have you tried?
I have tried the pivot table but problem is that i have to always change manually data then refresh the pivot table.
Can we do with the help of formula ?Please help..
a) You can use a COUNTIFS formula to check whether the first name/last name combination on Heads Data 1 occurs on Heads Data 2. If this formula returns 0, the employee is missing on the second sheet.
b) You can use an INDEX/MATCH formula to return the Job Description from Heads Data 1 on the Heads Data 2 sheet. You can then check whether it has changed.
c) You can also use INDEX/MATCH or VLOOKUP to return the surname (last name) corresponding to the first name from Heads Data 1 on the Heads Data 2 sheet. You can then check whether the surname has changed.
Sir, i am not making it.
Can you please write formula in attached file ??
Please...
Then i will understood better.Here is a attached file...