User Help

Reference result from Excel Filter function to be used in drop-down

I use the Filter function in Excel and successfully get a resulting list of values:

Now I want to reference that list to be used as the content of a drop down list – something like this:

As the resulting list is dynamic and will change in length from time to time, I don’t want to make a hard reference to lots of cells, I only want to reference the actual result and nothing else.

I think I saw somewhere that you should use a special character or something to reference the list, but I can’t find any information about how to do that when searching for it.

Leave a Reply

Your email address will not be published. Required fields are marked *