Answer's probably there, but what do you mean by "repeating numbered
rows"? I can think of several possible interpretations...

If you mean you want something like:

A
1 1
2 2
3 3
4 1
5 2
6 3
7 1

then one way is

A2: =MOD(A1,3)+1

Copy down as far as necessary

In article ,
Cassie wrote:

Countless efforts to 'find' how to do this...expect the answer 'is
there'...perhaps I just cannot see it. Thanks in advance for any assistance.