Need help on this formula!

  • Thread starter Thread starter olimits7
  • Start date Start date
O

olimits7

Hello,

I need help with a formula I'm trying to create. I have data in
column but the data is scattered. For example, there will be a numbe
in row 20 then it's blank until row 35, then blank until row 68, and s
on.

I need a formula that will copy the data to the rows that are blan
below it. For example, if row 20 has a number in it I want to cop
that number in the blank rows until it reaches the next number. An
once it reaches row 35 it will copy that number to the rows below i
and so on. I would do this manually but the spreadsheet is huge.

Thank you for your help,
Olimits
 
Let's say your data is in column A
In B1, enter

=A1

In B2, enter

=IF(ISBLANK(A2),B1,A2)

and copy down.

If you don't like the extra column, Copy column B, Select column A, Paste
Special, Values and delete the B column

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Hi
try:
- select this column
- hit F5, click 'Special', choose 'blank cells'
- enter the equation sign '='
- hit the upper arroy kea
- commit with CTRL+ENTER
 
Back
Top