I would like to create a column that states True if they're still active or
worked 6 months or more and false if they are no longer active.

"Shane Devenshire" wrote:

Do you want to count the number of people that meet your condtions or do you
want to create a True and False column so you can filter on them?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Reenee" wrote:

I have attached a worksheet that includes a few individuals that were hired
which represents 'True' and termed which represent 'False.' I have over 10K
rows and am trying to filter out only the information needed. This sheet was
ran as of 12/31/08 and the formula I need is to tell me who was still active
as of that date as you will see in the first row John Doe was hired 4/29/05
and it states true in column E (Active) John Doe is still active with the
company and I need some formula that will show me all of those individuals
who still state true, but in some cases there will be an individual such as
Jane Andrew who has multiple hire and term dates but the last line states
'True' which means she was active as of 12/31/08.


Also, Jane Doe was hired in 2008 and worked for 6 months or more and I need
a function that will show me all those who were hired and termed in 2008 but
worked for 6 months or more.

Is this possible to find a solution that will at least help me with one of
my problems.

Last Name First Name Hire/Term Date Active Fulltime Permanent
DOE JOHN 04/29/2005 TRUE FALSE FALSE
DOE JANE 01/18/2008 TRUE FALSE FALSE
DOE JANE 07/23/2008 FALSE TRUE TRUE
SMITH JON 07/10/2007 FALSE FALSE FALSE
SMITH JON 01/24/2008 FALSE FALSE FALSE
DOE JUSTIN 05/23/2003 TRUE FALSE FALSE
DOE JUSTIN 08/12/2003 FALSE FALSE FALSE
ANDREW JANE 05/29/2003 TRUE FALSE TRUE
ANDREW JANE 08/24/2005 FALSE FALSE FALSE
ANDREW JANE 12/16/2005 TRUE FALSE FALSE
ANDREW JANE 02/28/2007 FALSE FALSE FALSE
ANDREW JANE 05/11/2007 TRUE FALSE FALSE
ANDREW JANE 06/04/2007 FALSE FALSE FALSE
ANDREW JANE 07/28/2007 TRUE FALSE FALSE
ANDREW JANE 01/31/2008 FALSE TRUE TRUE
ANDREW JANE 04/30/2008 TRUE TRUE TRUE

I didn't know how to attach the spreadsheet.