Hi,

I am trying to write a formula that will work two different ways:
1. Give the month an employee left a role
2. Give the month an employee started a role

I have attached a picture of what the matrix looks like (I think...). The 1.0's represent the employee in that position for a given month.

I am struggling to know what formula to use.

Thanks in advance

wdasd.PNG