![]() Sheet1!$A$1 is the sheet and cell reference containing the name of the folder from which the files are to be listed.Ĭlick OK to close the New Name window. ![]() Within the New Name window set the following criteria:Ĭan be any name you wish, but for our example we will be using listFiles. Within the Excel Ribbon click Formulas -> Define Name The first step is to create a named range, which contains the FILES function. Create a named range for the FILES function The instructions below will show you step-by-step how to use it. The FILES function is based on an old Excel feature, which has to be applied in a special way. If you search through the list of Excel functions, FILES is not listed. But wait! Back away from the close button, there is another option.įor listing files in a folder we can also use a little-known feature from Excel version 4, which still works today, the FILES function. I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly. ![]() Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.
0 Comments
Leave a Reply. |