Displaying cell with latest date which contains specific text from a list of raw data
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?
screenshot to ask for excel answer.PNG