View Single Post
 
Old 08-23-2011, 01:23 PM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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)
Reply With Quote