ExcelBanter - Copy value below Cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy value below Cell (https://www.excelbanter.com/excel-worksheet-functions/76409-copy-value-below-cell.html)

Conditional Formatting

Copy value below Cell

I would like to know if there is a formula that would copy the value of the
data below it.
Sample: (I would like a formula to be created in column B and the result
will be the example below)

Column A Column B
1234 1234
----- 1234
----- 1234
3456 3456
----- 3456
9876 9876
---- 9876
---- 9876
---- 9876
123456 123456
---- 123456

Thank you in advance!

Dave Peterson

Copy value below Cell

Take a look at Debra Dalgleish's notes:
http://contextures.com/xlDataEntry02.html

Conditional Formatting wrote:

I would like to know if there is a formula that would copy the value of the
data below it.
Sample: (I would like a formula to be created in column B and the result
will be the example below)

Column A Column B
1234 1234
----- 1234
----- 1234
3456 3456
----- 3456
9876 9876
---- 9876
---- 9876
---- 9876
123456 123456
---- 123456

Thank you in advance!

--

Dave Peterson

All times are GMT +1. The time now is 02:40 PM.