MicrosoftWhen Macro4 was mainstream I was still writing in FORTRAN using a VAX780. I was a latecomer to the world of PCs and Excel so I am not that familiar with the functions it used except, perhaps, EVALUATE. I had rather assumed the string parameter for FILES was a folder as opposed to a full path but, having followed your suggestion, it works fine as an inbuilt filter.
I think it is going to be quite a while before the new 'tricks' available through the use of DA settle down. For example SEQUENCE is useful for creating cross-tab reports. In the case of the file listing
= INDEX( F, SEQUENCE(QUOTIENT(COUNTA(F),5),5) )
lists the files in 5 columns and provides an alternative to TRANSPOSE.
p.s.
=FILTER(List,BoldList)
worked perfectly, of course.
