Results 1 to 4 of 4

Formula for reading latest date

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    44

    Formula for reading latest date

    Hello everyone, I am in serious need of a formula in the next few hours. I have attached an excel form to show what I need. I need a formula in column G that will replicate "keep" and "delete" like it is shown in column C.

    Rules are -
    The formula needs to read the latest date in order to show "keep" for each ID in column E.
    Each identifier will have two dates that are the same, both should be "keep", but only for the latest date.
    If an identifier has one date, like LX4, it is a "keep".

    Does anyone know of a formula like this???? Please help....thank you!!!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  2. [SOLVED] Latest date based on vlookup - mistake in formula
    By mathieuv in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-03-2013, 04:22 AM
  3. [SOLVED] Formula to find the latest date of a specified occurance
    By happyhorse in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2013, 12:37 PM
  4. [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
  5. [SOLVED] date reading formula question
    By Todd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2006, 01:00 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