Listing Question

[superbeast326]

I have a list of eight names.

Is there a formula where I can make the first name repeat from a1:a6, second a7:a12, so on and so forth.

 

[superbeast326]

Could I please have a visual example?

 

[superbeast326]

What do you mean by qualify?

 

[Jon von der Heyden]

If I have a Name called 'Test' and that name refers to a range, then I would:

Invoke Data Validation
Choose List
And in Refers to enter: =Test

If Test has been scoped to a sheet (which is something you set when you insert a new name, the default is workbook) then it must be qualified:

In refers to enter: =SheetName!Test

Where SheetName is the sheet that it is scoped to.

 

[superbeast326]

How can I do that for two names

 

[superbeast326]

How can I create a named range that contains two formulas?

 

[superbeast326]

Please Help.

 

[superbeast326]

What I am saying is that, I have created two names with formulas that are used to return Text, this is determined by their positions. I want to have a data validation drop-down list to use the text that is going to be generated by the two formulas. I do not know how to Google the relevant resource to help me, your suggestion would be greatly appreciated.

 

[Jon von der Heyden]

I think you should be a little more patient and leave longer intervals before bumping.

I'm afraid that if you want a DV list then those two names have to be placed in a range (.e.g Z1:Z2). You can only feed DV lists with range objects.

 

[superbeast326]

I apologize, I saw that the thread was going to page 2, so I bumped as a response of panic. I get what your are saying. I have to put the first formula in the first column and the second formula in the second column, copy it down and DV from there, thank you very much, you are too kind. Once again, I apologize for bumping the thread.

 

[superbeast326]

By the way, all the counting functions can still work with Data Validation Right.