I have 2 excel files:
I want to fill in column J of the second file when the salary in column F is higher or more less than the salary indicated in the first file in column B. For example for the first line “Sony anderson” has a salary 40000 and as “commercial director” in the first file the average salary is 60000. I want to write a comment in column J “Salary lower than the average salary”.
Do you think that is it possible to do this?
Thank you for your help.