ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Counting Rows (https://www.excelbanter.com/excel-discussion-misc-queries/109989-counting-rows.html)

klafert

Counting Rows
 
I want 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???


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com