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.

 

[Jon von der Heyden]

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

I don't understand this question mate.

 

[superbeast326]

What I meant is can I use the COUNTIF(), SUMPRODUCT() and COUNTA() function with data from a DV List?

 

[superbeast326]

I really need to know, please.

 

[Jon von der Heyden]

Can you perhaps explain what exactly you are trying to do? What do you need the DV for and where?

The DV list needs to read a range of values. When applied to a cell it (typically) gives a user a drop-down from which to choose one item from that list.

I assumed you were using a DV list for the actual names. So be they constants you or formula you would need names in a range.

You can still use formulae to reference the DV list range, so if that is what you mean by use COUNIFS etc., then yes sure you can.

 

[superbeast326]

So that means if I were to put DV Lists in E2:E51, I can still use this formula
=SUMPRODUCT(COUNTIF(E2:E51,Names))

By the way, about the DV list, is it possible to make a DV list with these two texts, Yes and No, while making No the default text until it is changed to Yes?

 

[superbeast326]

I apologize for this in advance,

Bump.

 

[Jon von der Heyden]

So that means if I were to put DV Lists in E2:E51, I can still use this formula
=SUMPRODUCT(COUNTIF(E2:E51,Names))

By the way, about the DV list, is it possible to make a DV list with these two texts, Yes and No, while making No the default text until it is changed to Yes?

Yes to being able to use SUMPRODUCT(COUNTIF(E2:E51,Names))

And yes to DV, you just have to enter the No into the range as constants..

 

[superbeast326]

Thank you for your kind and prompt replies.