Excel Formula to List Files in a Folder (No VBA)
• Step 1: Copy and paste folder path, including final backslash: \
• Step 2: Create Named Range:
=LAMBDA(r,TRANSPOSE(FILES(r&"*")))
(Non-Volatile)
or
=LAMBDA(r,TRANSPOSE(FILES(r&"*")) &T(NOW()))
(Volatile)
• Step 3: Use new formula and point to folder path to get filenames