Results 1 to 5 of 5

Extracting two letters-code based on earliest date

Threaded View

  1. 05-07-2014, 03:45 PM #1
    Niclal
    Niclal is offline
    Forum Contributor
    Join Date
    10-06-2012
    Location
    Basel, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    157

    Extracting two letters-code based on earliest date

    Hi All,
    I have in my report semi-colon separated items that have following format: two letters-Code+dash+number+space+date, e.g. US-199625985P 19960912
    I would like to extract the two-letters code from the item that has the earliest date (see attached sheet).
    I really appreciate your help

    Niclal
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index match multiple criteria based on earliest date
    By dchubbock in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-28-2013, 07:18 PM
  2. LookUp based earliest date (2007)
    By D_N_L in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2012, 08:19 AM
  3. Find earliest date based on specific criteria in other columns
    By cat2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2011, 11:50 AM
  4. Find earliest date based on certain criteria
    By SeanKosmann in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-26-2010, 11:32 AM
  5. Find Earliest Date based on conditions
    By ShredDude in forum Excel General
    Replies: 6
    Last Post: 07-14-2007, 01:56 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1