Hi,

while defining a name, instead of actual range, you can use formula
like this:

=offset(b1,0,a1,1,7)

supposing that your values
(5,2,7,4,1,6,3,8,9,5,2,7,4,1,6,3,8,9,5,2,7,4,1,6,3 ,8,9 ) are in second
row, starting at b1, and the cell which contains 5 is a1.

Did it help?

Regards,
Ivan