Hi,

I've used the offset function in the past to create a dynamic range
that can then be used for data validation. I'm wondering if I can
create a range using offset, and add to it another arbitrary list
value. i.e., a sample dynamic list might be:

red
yellow
blue

but I want to create a list like:

all
red
yellow
blue

Where the value 'all' doesn't exist in the range created by the offset
function.

Thanks in advance for any help.

David