View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klafert klafert is offline
external usenet poster
 
Posts: 127
Default 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???