Auto Extended Drop Down List

Learn to and be excel mind: With this basic tutorial learn to create auto extended drop-down list, no need to change range when you add or deleted data from list

We have used name range option and referred that to offset and CountA formula.

Formula we used is =OFFSET(Sheet2!$B$9,0,0,COUNTA(Sheet2!$B:$B),1)
*Sheet2 refer to the where your list exist so amend it as per your sheet name

Excel Mind Blog:
excelmindd.blogspot.com/

Twitter Handle:
twitter.com/Excel_Mind

Instagram Handle:
www.instagram.com/excel_mind21/

Playlists:
Dashboard:
   • Dashboard Training In Excel  - Speedometer...  

Lookup:
   • Dashboard Training In Excel  - Speedometer...  

VBA:
   • Numbers To Words In Excel  

Without VBA:
   • Get List Of File In Folder Without VBA  

#excelmind #excel #vba #vlookup #knowledge #dropdown #tutorial #advanceexcel #microsoftexcel #workbook #dropdownlist #freetutorial #learning #datavalidation #msexcel #excelsecurity #exceltips #offset #presentation #countach #visualbasic #formula
#excelformula #exceladvance #analysis #excel365 #exceltutorial #english #englishsubtitle #transcript #excelformulasandfunctions #exceltips #exceltricks #exceltrick #shortcut #excelshortcuts #list