Thread: update column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default update column
Another one:

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

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

--

Dave Peterson
Reply With QuoteReply With Quote