Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-23-2011, 12:48 PM
apolloman apolloman is offline Selecting blank cells in criteria Windows XP Selecting blank cells in criteria Office 2007
Novice
Selecting blank cells in criteria
 
Join Date: Apr 2011
Posts: 16
apolloman is on a distinguished road
Default Selecting blank cells in criteria

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting blank cells in criteria 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
Selecting blank cells in criteria 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft