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: https://excelmindd.blogspot.com/ Twitter Handle: https://twitter.com/Excel_Mind Instagram Handle: https://www.instagram.com/excel_mind21/ Playlists: Dashboard: https://www.youtube.com/watch?v=xz8QHbwh5gk&list=PLKJEcKg9BIOF1C6h2fyuX_31z0PDd47JM Lookup: https://www.youtube.com/watch?v=xz8QHbwh5gk&list=PLKJEcKg9BIOF1C6h2fyuX_31z0PDd47JM VBA: https://www.youtube.com/watch?v=nOVzHQLfiS0&list=PLKJEcKg9BIOGhew45uD58J0uNsz-TUCmf Without VBA: https://www.youtube.com/watch?v=neqHpUkPXvg&list=PLKJEcKg9BIOFT-gjYy-Ay2Hn1UJetkgBX #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