Hi All!

I have attached a copy of the spreadsheet i am working on. I need a formula that works as below to go into the difference column.

Basically I need a formula to look at the two staff number columns and then if they are the same to look at the two FTE columns, if these are the same then the difference will be 0 if there are changes I would like to know what the change was whether a positive or a negative depending if the FTE is lower or higher than the previous month. In some cases staff numbers in the first staff number column A will not be in the staff number column C which is okay i just need to know once again the difference in the FTE.

If a staff number in column A is no longer in staff number column C then the employee has probably resigned so if their FTE was 1 the difference will be -1.
If a staff number in column C is now there and is not in column A then the employee is probably new so if their FTE is 1 the difference will be +1.

I hope this makes sense!

Help!

Thanks

FTE Formula Workbook.xlsx