Drop down list with values 5, 10, 15, ..., 30 - Possible to include cell-reference also?

Hi all,

I have created a drop down list predefined with values 5, 10, 15, 20, ..., 30. This is for the purpose of calculating statistics on a large table using OFFSET. Usually, I'm most interested in the recent past, but I would like to include the option of viewing the entire table.

For this table that would be cell F5 = 1500. I find 1500 using a COUNT formula. F5 is a dynamic value as the table can both grow and shrink.

Upon creating this question I realized I could accomplish this by simply creating a range where the bottom cell references F5.

I still wonder if this is possible to accomplish directly in DataValidation by a formula as it would negate creating a lot of lists in other documents also.

Thanks in advance.

Hi, 6StringJazzer,

That works well, although I still have to create a reference in my sheets. No problem though. I was merely curious if there existed a formula I could enter directly in the Data Validation field.

Thanks for helping.

Elijah