update column

[markielou]

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

 

[Barb Reinhardt]

How about

=A1 & if(MOD(row(),17) = 0,17,mod(row(),17))

 

[markielou]

perfect, thanks so much-

 

[Dick Kusleika]

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

=A1&IF(MOD(ROW(),16)=0,16,MOD(ROW(),16))

 

[Dave Peterson]

Another one:

=A1 & MOD(ROW()-1,17)+1

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

 

[Dave Peterson]

1 through 16!

=A1 & MOD(ROW()-1,16)+1

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