The easiest solution would be to add a field in your data model that lets you keep track of who's left and who's current. You can then use another listbox with that field to select only the active sales representatives.
Alternatively you can try something like:
=If(NOT match([Sales Rep Description], ....comma separated list of values here.... ), [Sales Rep Description)
That will indeed be the easiest way but there are also sales representatives who doesn't work at the company anymore since last month for example and we want to see what the turnover is for the last 2 seasons.
The formula is working, there is only 1 value I can not add to the formula and that is 'Royalty BV's'.
I think it's not working because of the BV's so I tried BV"s and BV''sbut that's also not working.
Do you perhaps have a solution for that too?