![]() The 1st Table created in a workbook is named Table1. To format range A2:B10 in above picture as a table ref. Consequently our new name will be part of the resized Table range ![]() In the 1st row below the current Table (so that would be row #11) the Table is auto-resized. In other words, as soon as we add (in the above example) a new First or Last name NB The drop-down list is shown next to the initial data (First Name & Last Name) but can be anywhere else in the workbookīecause a Table (exists since Excel 2007) offers dynamic ranges. The expected drop-down list is in E3 below And because we cannot change the initial data where there are blanks, we don't these blanks in our list.SORT functions - at the bottom of the article) (updated on Feb 7th, 2020: added options with Excel 365 List unique names auto sorted excluding blanks
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |