Hi
There is no need to use an advanced filter.
Turn on the standard filter so you have arrows against each column header.
Then click on the arrow by the "Term" header and untick all sections except the one marked blank.
You will then be presented with just the employees who have no termination date against their name.
Good luck.
Tony(OTPM)
|