Get List Of File In Folder Without VBA

Excel mind - Get complete list of file name from folder by declaring path under specific cell (Without VBA) - English Subtitle

* Formula for Name manager (Type =Files then open bracket and click on the cell where you written the path):

=Files(Sheet!$A$)

* Formula to get list (Change the Namelist to name which you set under name manager):

=IFERROR(INDEX(Namelist,Row()),"")

* Excel Mind Blog:

* Twitter Handle:

#excel #vba #Namemanager #knowledge #excelmind #tutorial #advanceexcel #microsoftexcel #dynamic #speedometer #freetutorial #learning #Filename #msexcel #folderpath #pivot_table #pathfinder #getfilepath #presentation #presentationskills #visualbasic #createformula #excelmind #hidden #excelhacks #excelfreelearning #freelancing
#formula #excel-formula #excelmind #exceltutorial