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
コメント