+ Reply to Thread
Results 1 to 2 of 2

Multiple criteria formula with date as criteria

  1. #1
    Forum Contributor
    Join Date
    05-02-2017
    Location
    NoVa, United States
    MS-Off Ver
    Microsoft 365
    Posts
    152

    Multiple criteria formula with date as criteria

    Right now I have a report that pulls a lot of changes to someone's work record. So, when they change job titles. I'm interested in the Entry date - the date when the employee actually went into the job title. Also, I'm only interested in a select range of job titles. I've attached an excel.

    Basically I want to know the *earliest* entry date a person has for the specific job title I'm interested in. For example, on the attached report, for Jimmy Jones (rows 2 - 5). I'm interested in the *earliest* entry date that Jimmy had that title. On the report, he's got Ops Officer 2 for both rows 2 and 3 - both have different 'codes' (I'm interested in both codes, BUT they reflect the same job). Since they both reflect the same job, I'm only interested in the earliest Op Officer 2 (row 3, entry date 7/5/14).

    Right now, I figure, a count if to tell me which rows have codes I'm interested in. I'd delete the other ones. This isn't very efficient and also doesn't account for the Jimmy double job problem.

    Anyone have any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Multiple criteria formula with date as criteria

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count with multiple criteria (Date, Time and Other Criteria)
    By Naren_Kumar in forum Excel General
    Replies: 6
    Last Post: 06-25-2018, 05:53 PM
  2. [SOLVED] Index Match with multiple criteria and date criteria
    By snolem75 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2018, 03:51 PM
  3. Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  4. Replies: 4
    Last Post: 04-14-2017, 05:14 PM
  5. Formula for summing on multiple row criteria and a dynamic column criteria
    By ianswilson815 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2016, 01:58 PM
  6. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  7. Multiple Criteria Date Formula
    By Nadir Soofi in forum Excel General
    Replies: 1
    Last Post: 03-25-2009, 06:27 PM

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