Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 06, 02:31 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 114
Default 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   Report Post  
Old December 18th 06, 02:48 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 347
Default 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   Report Post  
Old December 18th 06, 03:41 AM posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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   Report Post  
Old December 18th 06, 07:01 AM posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
Excel should let you fill alternate rows automatically McNaddy Excel Discussion (Misc queries) 0 October 9th 06 11:13 AM
Counting Rows - Fill ??? klafert Excel Worksheet Functions 1 September 16th 06 07:11 PM
Increase the maximum number of rows Mortego Excel Discussion (Misc queries) 3 June 29th 06 02:03 PM
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM


All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017