How about

=A1 & if(MOD(row(),17) = 0,17,mod(row(),17))
--
HTH,
Barb Reinhardt



" wrote:

Hopefully someone can help me with this simple task:

I have one column (A) with various text values, and I need to update
column B with the following:
"value in A1" & 1 for row 1
"value in A2" & 2 for row 2
..
..
..
then after row 16 I need it to start over with:
"value in A17" & 1 for row 17
etc... on down to the end of the range

Does anyone know how to do this?

Thanks,
Greg