Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
Pivot tables - Fill In All Rows | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
Counting rows with 3 columns | Excel Worksheet Functions |