Pulls names from list in order

[jeffreybrown]

In this file, I would like to pull names in order from the list in column K, and when you get to the end of the list in column K, start over with the first name in the list.

Columnn E does that for me, but in this case, I would actually like to pull the results as in Column F. In other words, use each name twice before going to the next name in the list.

[Glenn Kennedy]

Try:

=LET(A,K2:K9,B,ROWS(A),C,3,D,3,INDEX(A,1+MOD(1+INT(SEQUENCE(B*C*D,,0)/D)-1,B)))

where C is the number of times the entire list is to be repeated and where D is the number of repetitions of each name within each cycle.

[jeffreybrown]

Hi Glenn,

This is perfect. Thank you for your time.