After striking out staff AB's name and replacing it with staff BC, the swap algorithm is unable to swap staff BC at the same date anymore cuz the content of the cell is no longer staff BC but staff AB staff BC, and the algorithm doesnt recognise that.
Suggested fix:
Swap the ordering between the striked name and the new name. modify the algo to match the first unstriked string to the swap target's name.
After striking out staff AB's name and replacing it with staff BC, the swap algorithm is unable to swap staff BC at the same date anymore cuz the content of the cell is no longer staff BC but
staff ABstaff BC, and the algorithm doesnt recognise that.Suggested fix:
Swap the ordering between the striked name and the new name. modify the algo to match the first unstriked string to the swap target's name.