Populate a range from the first value in the area [SOLVED]

[3G]

Hello-

I'm stumped! I have some blank rows I am trying to avoid filling in manually:

A|

AB|


CD|


DE|


There are ALWAYS 9 rows between values. What I want is all of the blanks populated with the value above it...so:


AB

AB

AB

CD

CD

CD

DE

DE

DE


etc....


I tried the Ctrl+enter trick, but that means I have to manually select all 7000 rows. Any formula suggestions?


Thanks

3G

 

[shrivallabha]

1. Set Autofilter

2. Filter on blanks

3. In the topmost blank cell [lets say A3] write formula:

=A2

4. Copy this down to the last row [up to which you need to populate data]


You are done :D

 

[3G]

Thanks Shrivallabha. I was doing the ctrl+enter trick wrong!!! I was typing the "=" portion into the formula bar...rather than the cell itself.


Thanks for your input too!