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.
Bookmarks