ExcelBanter - Discontinous values in a column

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

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

- - Discontinous values in a column (https://www.excelbanter.com/excel-discussion-misc-queries/251797-discontinous-values-column.html)

Discontinous values in a column

How can I fill in the empty cells in a column like the following :
4525980367

4525980560
4525988472

4526001271

4526005001

4526026221
4526051700
4526082664
4526131807

4526155800

4526174165
4526288621
4526336940

4526383124
4526384755

4526412139
4526454480
4526461206

4526463275

Ms-Exl-Learner

Discontinous values in a column

What do you want to fill in the empty cells whether the values of the
previous cell or a stable value?

--------------------
(Ms-Exl-Learner)
--------------------

"FA" wrote:

How can I fill in the empty cells in a column like the following :
4525980367

4525980560
4525988472

4526001271

4526005001

4526026221
4526051700
4526082664
4526131807

4526155800

4526174165
4526288621
4526336940

4526383124
4526384755

4526412139
4526454480
4526461206

4526463275

Bernd P

Discontinous values in a column

Hello,

Do you have something in mind like my example at the bottom of this
page:
http://sulprobil.com/html/w-rule.html
?

Regards,
Bernd

All times are GMT +1. The time now is 01:17 AM.