I first determine the number of entries in customList by using =COUNTIF(customList "") I have three lists, let's call them longList (B1:B500), customList (A1:A10) and actualList (C1:C510). I'd like to add a user defined list at the beginning of the long list to enable users to quickly select often used choices.Īfter some tinkering, I got it to work as follows (you might want to take a look while reading on.) Use case would be like this: I've got a long list (~500 entries) of options to choose from. I found this article while searching for a way to create a dynamic dropdown list, but not in the sense described here. Previous entries in those spreadsheets containing entries no longer in the list do not change. Then if you need to, just change the contents of the cell range and the list updates. If the range is in a different sheet, add the absolute sheet reference in front, like this. You need the $ to make the reference absolute. To type a range in the same sheet, type something like this: If you want the list in multiple cells, select multiple cells.Ĥ. Click in the cell where you want the list to appear. So you make a list of the projects that references a cell range in a sheet called Projects, say, and all you need to do is update that one cell range to make all the lists update.ġ. Howeve, you don't want to have those projects typed in that dropdown list because then if you change it, or use this spreadsheet next year, you'll have to correct the list 120 times. You would like to list the Official projects rather than having them type in whatever. They're summarizing what they've done this year, and you want them to list the projects they've worked on. Let's say you've got a spreadsheet documenting the year's performance for the 120 people in your company, one sheet for each person. However, what I haven't talked about yet is how to make a dynamic list. Some background: under Data > Validity, you can control what people can enter in spreadsheets, and offer them help in the form of lists, help tips, etc.Īnd elsewhere on my blogs. Rather than embedding it in the formatting, it's good. I just started using feature this recently, for my LinuxWorld
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |