Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Down In Rows But Want to Increase By Letter
Hi I want to fill down by rows say c3,c4,c5 so on but want it to fill by
letter. Example I want c3 to be c4 c4 to be d4 c5 to be e4 with the 4 staying constant but go up by letter going down a row. Hope this makes sense. The c4,d4,e4,are results from another sheet. Thanks Karl |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Down In Rows But Want to Increase By Letter
Hi,
Try this: =INDIRECT(CHAR(66+ROW(A1))&4) HTH Jean-Guy "Karl" wrote: Hi I want to fill down by rows say c3,c4,c5 so on but want it to fill by letter. Example I want c3 to be c4 c4 to be d4 c5 to be e4 with the 4 staying constant but go up by letter going down a row. Hope this makes sense. The c4,d4,e4,are results from another sheet. Thanks Karl |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Down In Rows But Want to Increase By Letter
Sounds like you want a dynamic transpose to Sheet1's C4:IV4 ..
In Sheet2, Put in the starting cell, ie in C3: =INDEX(Sheet1!$C$4:$IV$4,,ROW(A1)) Copy C3 down as far as required (maximum copy down is to C256) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Karl" wrote: Hi I want to fill down by rows say c3,c4,c5 so on but want it to fill by letter. Example I want c3 to be c4 c4 to be d4 c5 to be e4 with the 4 staying constant but go up by letter going down a row. Hope this makes sense. The c4,d4,e4,are results from another sheet. Thanks Karl |
#4
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 |