+ Reply to Thread
Results 1 to 3 of 3

Displaying cell with latest date which contains specific text from a list of raw data

  1. #1
    Registered User
    Join Date
    04-15-2019
    Location
    Singapore
    MS-Off Ver
    2016 EXCEL
    Posts
    14

    Unhappy Displaying cell with latest date which contains specific text from a list of raw data

    Displaying cell with latest date which contains specific text from a list of raw data

    Please help!

    In my excel sheet, i wanted to display in "$E$2" the latest result from a list of results in column A containing a specific number "5445". I tried to use the below formula to display the date of the latest result but its not working out as I got a "0" in the cell. Am I doing this wrong?

    =MAX(IF(A2:A9=ISNUMBER(SEARCH("5445",A2:A9)),B2:B9))


    screenshot to ask for excel answer.PNG

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Displaying cell with latest date which contains specific text from a list of raw data

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Displaying cell with latest date which contains specific text from a list of raw data

    Welcome to the forum

    Please the the following in E2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This is an array formula and must be committed using CTRL-SHIFT-ENTER

    Make sure that cell E2 is formatted as a date.

    Hope this helps
    Last edited by GeoffW283; 04-15-2019 at 10:12 PM.

+ 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] Data validation - drop down list - latest date
    By dunnobe in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-14-2017, 06:25 AM
  2. Displaying a Number if a specific cell contains specific text
    By Connor.pa in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-07-2017, 08:16 AM
  3. [SOLVED] Display latest date when specific text occurs
    By jhudson444 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2015, 04:25 PM
  4. Replies: 10
    Last Post: 04-11-2014, 03:11 PM
  5. [SOLVED] Displaying Specific Text in Cell Based on Text in Another
    By wowcrofty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2012, 12:11 PM
  6. [SOLVED] Macro to to select latest date in cell with validation list consisting of dates.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2012, 04:41 AM
  7. Replies: 7
    Last Post: 06-08-2012, 10:02 AM

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