Closed Thread
Results 1 to 3 of 3

Formula that will give me True or False results

  1. #1
    Registered User
    Join Date
    01-31-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    18

    Formula that will give me True or False results

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Formula that will give me True or False results

    Hi, Try the attached for the first part.
    For the second part, do you require the total time (for each staff member)worked in 2008 (i.e. the sum of all the periods worked within 2008, or the period from the first engagement in 2008 to the last.
    Regards Mick
    Attached Files Attached Files

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Formula that will give me True or False results

    Please continue on your original thread... do not ask the same questions in multiple threads!

    http://www.excelforum.com/excel-gene...-function.html
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1