Forum Discussion
=Folder()
Heres a quick question, I know that in Excel, Using Named Formulas we can do =FILES({cellRef}&"*") and in the {cellRef} have an address like "C:\Docs\" then a formula =Index({NamedFormaula,ROW(A1))...
ExcelExciting genius, I cant believe, even though I have been fiddling with this area for lots of other things I hadn't thought of that. that's amazing!
Stephen_Edwards Glad to hear your query is resolved 😃👍
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com