Kelli Webb
Member
Hi,
I'm hoping you may be able to assist. I have given this one a good go, but I'm still falling short
Column K - is what the results should be
Column M - provides why my result differs i.e. why my formula is wrong
thank you and take care,
I'm hoping you may be able to assist. I have given this one a good go, but I'm still falling short
- if Joined column D = pos start column H And is >= 1/4/2019 but <= 31/3/2020 -------- result would be "New"; Or
- if the Staff Member column A is the sames as the next row And there is a change in Position column G ------- the result would be "Yes"
- if neither of the above criteria is met ------ the result would be "No"
Column K - is what the results should be
Column M - provides why my result differs i.e. why my formula is wrong
thank you and take care,