Counting Rows - Fill ???
 

I would like a formula tha will count columns. I was using the fill down in
series, its been a while, but I though I could tell it to start at 1 end at
27 and start over at 1 and goto 27 until all the lines that contains data or
in a range are counted.

When I use the fill down I put the stop value at 27 and in the 1st column I
have a 1 and that works. But I have to Manually do this ever 27 columns. I
thougth I could use trend or???

Counting Rows - Fill ???
 

Try this:

=MOD(ROWS($1:1),27)+(MOD(ROWS($1:1),27)=0)*27

Copy down as needed.

Biff

"klafert" wrote in message
...
I would like a formula tha will count columns. I was using the fill down
in
series, its been a while, but I though I could tell it to start at 1 end
at
27 and start over at 1 and goto 27 until all the lines that contains data
or
in a range are counted.

When I use the fill down I put the stop value at 27 and in the 1st column
I
have a 1 and that works. But I have to Manually do this ever 27 columns. I
thougth I could use trend or???