Excel 2007 help.

BYTEr

BYTEr

BYTEr

Associate
Joined
2 Oct 2004
Posts
1,048
Hi all,

Wondering if anyone could help, in an excel spread sheet I need an option to auto-fill certain columns, similar to when you double click the bottom right corner of the cell, only issue is, there’s lots of different values in the column. So I have a certain value in row 2, then blank down to row 16, then in row 17 it’s a different value which I then need to auto-fill all blank cells under until the next value and so on. Is there a way to achieve this? Thanks in advance.
 
How many values are we talking? Surely it's just easier to bulk fill what you need?

Or do you need to automate it for some reason?

record a macro?
 
About 9000, I've done it now though, was a simple 5 second thing to do which I've done multiple times before, just had a brain fart this morning.
 
If you're doing it as a one-off, one way would be
- set a filter on the column and filter on only the blank cells
- in the first of the filtered blank cells (e.g. C10), add the formula =C9 (i.e. the cell above with a value)
- copy the formula down to remaining blank cells
- remove the filter

Another way would be to create another column (e.g. D) to the right of the one with your numbers in, put a formula "=IF(ISNUMBER(C2),C2,D1)" into D2 and copy it down.

Edit, too slow!
 
You must log in or register to reply here.
Back
Top Bottom