Forum Discussion
Personalized drop-down lists
Hi there! I've been trying for hours to create a auto-fill formula that will allow me to populate a list based on a few rules. Youtube tutorials seem to only talk about simple 1, 2, 3, 4 lists. I...
Colleen_Terry Hopefully this is what you were going for...
Example 1:
=LET(
n, SEQUENCE(29),
n & "-" & n+1 & " min"
)
Example 2:
="T" & TEXT(SEQUENCE(29,, DATE(2024,2,1)), "dd-mm-yyyy")
Note: if it is your intention to use either of these formulas within Data Validation, they won't work directly as the List Source. However, you can enter the formula in cell A1, for example, then create a Data Validation rule in another cell, where the List Source is simply:
=$A$1#
The spilled range operator (#) will dynamically reference the entire list.
djclements Thanks for your reply! Unfortunately I have such a basic knowledge of Excel that I don't know what any of this means. I suppose what I should really do is find a beginners online course to get a better grasp of basic functions before I try and hit the more advanced ones.
Any suggestions on courses you are familiar with, either on Youtube or through an official website, would be great.
I gotta remember - walk before run!
Thanks again!
