| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Down In Rows But Want to Increase By Letter
"pinmaster" wrote:
=INDIRECT(CHAR(66+ROW(A1))&4) This would work but only till col Z. Perhaps one way to skirt the col letter incrementing problem (Z, AA, ... IV) is to use INDEX, eg: =INDEX(Sheet1!$C$4:$IV$4,,ROW(A1)) which allows a straight copy down to transpose the source sheet's cols C to IV -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Excel should let you fill alternate rows automatically | Excel Discussion (Misc queries) | |||
| Counting Rows - Fill ??? | Excel Worksheet Functions | |||
| Increase the maximum number of rows | Excel Discussion (Misc queries) | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Hybrid Mode
