Excel List help

[AndrewD04]

Hi Guys,

I am working on a piece of work where i ahve a list of names and dates next to them.

What i would liek to do is excel to scan all the dates and any date less than today to return the name to the left of the date however i only want it to build a list of names that have expired and not a full list with blanks.

Sample Data
Kerry 30/07/2019
Steve 16/05/2019
Clare 15/09/2019
John 14/08/2015

Results i would like
Kerry
Steve
John

Thanks

 

[tyija1995]

Hey,

Is this something you're after?

	A	B
1	Sample Data	Results
2	Kerry 30/07/2019	Kerry
3	Steve 16/05/2019	Steve
4	Clare 15/09/2019
5	John 14/08/2015	John

<tbody>
</tbody>

Where B2 has the formula (dragged down):

<today(),trim(left(a2,len(a2)-10)),""),"")

IFERROR(IF(EDATE(RIGHT(A2,10),0)<=TODAY(),TRIM(LEFT(A2,LEN(A2)-10)),""),"")

The main assumption here is that the string in column A always ends with a date in dd/mm/yyyy format (i.e. exactly 10 characters)</today(),trim(left(a2,len(a2)-10)),""),"")

 

[steve the fish]

Id have thought that the names are in one column and the dates another. If so try this array formula that requires CTRL-SHIFT-ENTER

=IFERROR(INDEX($A$1:$A$4,SMALL(IF($B$1:$B$4 < TODAY(),ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($A$1:A1))),"")<today(),row($b$1:$b$4)-row($b$1)+1),rows($a$1:a1))),"")< html=""></today(),row($b$1:$b$4)-row($b$1)+1),rows($a$1:a1))),"")<>