ExcelBanter - Filling in Cell above with Data from below

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filling in Cell above with Data from below (https://www.excelbanter.com/excel-discussion-misc-queries/251183-filling-cell-above-data-below.html)

Filling in Cell above with Data from below

Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on:

Col A
123
XXX
345
YYY
Need it to end up like:

XXX
XXX
YYY
YYY

How can I do this?

Filling in Cell above with Data from below

If A1 and A3 are blank:
Select A1:A4. Press Ctrl+G. Click special, blank.

Start typing a formula:
=

Then press the down arrow key. This should finish the formula and create:
=A2

Press Ctrl+Enter to apply formula to all currently selected cells.
If needed, you could then do a copy, paste special - values only.
=======

If A1 and A3 are not blank, but you want every other line copied upward:
In helper column B, cell B1:

=IF(MOD(ROW(),2),A2,A1)

Copy down as needed.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"CUTiger" wrote:

Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on:

Col A
123
XXX
345
YYY
Need it to end up like:

XXX
XXX
YYY
YYY

How can I do this?

Filling in Cell above with Data from below

Worked great!!!!!!!!!Thanks for the help.

CUTiger

---
frmsrcurl: http://msgroups.net/microsoft.public...ata-from-below