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
Bookmarks