Excluding items of a list based on criteria

[ImranBhatti]

Hi,

In the attached workbook I have a named range in A column "AllFiles" in cell B1 I have another name that I would not like to add in the list.

Other items to exclude

Any item that does not starts with a date. It may include a date at the end but not in the beginning.

I have highlighted the pattern of items that I want to exlcude.

The output is shown in the C column manually which needs to be driven using formula.

Best Regards
Imran Bhatti

[Fluff13]

How about
=INDEX($A$3:$A$41,AGGREGATE(15,6,(ROW($A$3:$A$41)-ROW($A$3)+1)/(($A$3:$A$41<>$B$1)*(NOT(ISNUMBER(--LEFT($A$3:$A$41,10))))),ROWS($A$1:$A1)))

[Bosco]

Or,

In B3, copied down :

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$3:A$41)/(A$3:A$41<>B$1)/ISERR(-LEFT($A$3:$A$41,10)),ROWS($1:1))),"")

Regards
Bosco

[ImranBhatti]

Thanks @Fluff13 and Bosco

Solutions of both'ov you are working as required.

Much appreciated

[Fluff13]

You're welcome & thanks for the feedback