agent.xlsx

hi,
here attached is the solution I'm proposing, even if I'm sure someone will suggest you something better :-)
AL
PS:the formula of the yellow cell is an array formula, so CTRL+SHIFT+ENTER to commit it (not just ENTER)