| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying down while changing columns
In one cell I have the following formula: =COUNTA(B2:B1000). Copying down I like ti to change the column to
=COUNTA(C2:C1000) =COUNTA(D2:D1000) and so on. I have tried OFFSET and TRANSPOSE but can't get it to work. Any ideaes? Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving Current Row,Columns & copying Format from Row,Columns a | Excel Programming | |||
| copying formulas but changing the column # | Excel Discussion (Misc queries) | |||
| copying VLOOKUP w/o changing formula | Excel Worksheet Functions | |||
| copying changing range | Excel Programming | |||
| Copying a formula and changing ONE value... | Excel Worksheet Functions | |||
Threaded Mode
