|
|
#2
08-23-2011, 01:23 PM
|
|||
|
|||
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) 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to organize and insert blank cells between a huge number of data?
|
tareq | Excel | 12 | 09-29-2010 02:12 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
| Using both drop down lists and blank cells for text | voltarei | Word | 0 | 03-18-2010 04:16 AM |
|
How to turn all blank lines into non-blank for legal forms
|
sieler | Word | 3 | 04-12-2009 01:38 PM |
| How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode