![]() |
#1
|
|||
|
|||
![]()
I am doing an advanced filter to select employees that are still working with the company. In the data range there is a column labeled Term. If the employee is terminated the cell by their name in the Term column has the date of their termination. If the person is still with the company the cell is blank. To select current employees, the criteria I tried to use is as follows:
Term ="" This definitely does not work, the filter selects nothing. Would someone tell me how to rewrite this to select employees that are still with the company? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |