| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fill Down .. with a twist
Hi,
select the range on the A column, press F5, special select in blank cells only, in a2 type =a1 and press CTRL+Enter hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "mmb" escreveu: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| Fill handle formula | Excel Worksheet Functions | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Hybrid Mode
