LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mmb mmb is offline
external usenet poster
 
Posts: 17
Default Fill Down .. with a twist

I know I've done this before.. but for the life of me I can't figure out how.

I need to fill down on a column, however, the value changes every 4th
column.
Example:
Smith 1
2
3
4
Jones 1
2
3
4

And I need it to read

Smith 1
Smith 2
Smith 3
Smith 4
Jones 1
Jones 2
Jones 3
Jones 4

I recall a quick fill method... one of those fuzzy recollections at the
edge of my brain.. but I just can't grasp what it was? Can anyone help?

Thanks!
 
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
I have a list of data, fill in the gaps. FILL function won't work Triv Excel Discussion (Misc queries) 1 September 17th 05 02:33 PM
Fill Effects on Fill Color Rugdoody Excel Discussion (Misc queries) 1 September 14th 05 06:45 PM
Fill handle formula neeraj Excel Worksheet Functions 9 September 13th 05 01:46 AM
The fill feature in Excel that gives option to fill or copy KAHelman New Users to Excel 1 July 29th 05 07:47 PM
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM


All times are GMT +1. The time now is 11:39 PM.

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

About Us

"It's about Microsoft Excel"