+ Reply to Thread
Results 1 to 4 of 4

Formula to return latest date for items, and also a formula to return value in same row.

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Cincinnati
    MS-Off Ver
    2010
    Posts
    35

    Formula to return latest date for items, and also a formula to return value in same row.

    I have a large record.

    I have serial numbers, which have many entries on the worksheet.
    I need values, for each serial number, that are associated with both the latest and earliest date.

    So basically I want to look for the Serial number, check which entry for that serial number has the latest date and time, and then return that value.
    Then, in another column, look for the serial number, check which entry is the earliest date and time, and return the value.

    Example

    Please Login or Register  to view this content.
    For serial code 123, I'd want to return the latest date's (and time's) value in one formula, which would be 1.34
    Also the Earliest which would be 12.34

    for 456 it would be 5.67 for the latest and the other formula would return 4.566

    for 789 both would return 1.34.

    Thanks. Any help is appreciated!

  2. #2
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    Re: Formula to return latest date for items, and also a formula to return value in same ro

    If you have large numbers of records, formula will not be efficient because it's resource intensive. I recommend you put it in a pivot table, and put the date in values and change the calculation to max value.

  3. #3
    Registered User
    Join Date
    07-18-2013
    Location
    Cincinnati
    MS-Off Ver
    2010
    Posts
    35

    Re: Formula to return latest date for items, and also a formula to return value in same ro

    Gotcha. I can just do a vlookup on the Max and min dates once I have those. (since it includes time as well, should work fine). Thanks.

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    Cincinnati
    MS-Off Ver
    2010
    Posts
    35

    Re: Formula to return latest date for items, and also a formula to return value in same ro

    actually, if anyone could show me a formula that would work, I'd still appreciate it. VLookup wont work for me. I am guessing because even though it isn't common, some times the dates and times arent unique.

+ 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. [SOLVED] Return the value from the row with latest date
    By G.Bregvadze in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 09:14 AM
  2. [SOLVED] Formula required to return 2 latest records in a date range
    By Backroomgeeza in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 10-23-2012, 05:53 AM
  3. [SOLVED] Return latest Date from cell containing several dates?
    By Motox in forum Excel General
    Replies: 2
    Last Post: 09-10-2012, 07:26 AM
  4. Excel 2007 : Lookup a value and return the latest date
    By pinkshirt in forum Excel General
    Replies: 4
    Last Post: 07-04-2011, 06:13 AM
  5. Replies: 1
    Last Post: 06-30-2010, 04:36 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