Forum Discussion
Query related to drop down
Excel Well, since you are working with an outdated Excel version it's not going to be more dynamic than that. At least, not when you want to add new entries at the bottom of the table. Consider entering new car makes at the top then. Right-click on the first cell in the Car column.
Excel Then add a column to the table indicating the sort order you want (or just a 1 for only the last entered name and then sort that column.
This is a nice method.
So what should i put formula to apply this process and connected to Cars column and it should be dynamic ?
- Ok, Thank you so much sir
Excel Well, since you are working with an outdated Excel version it's not going to be more dynamic than that. At least, not when you want to add new entries at the bottom of the table. Consider entering new car makes at the top then. Right-click on the first cell in the Car column.