# hourly value to copy the same value every 15 minutes

#### voltages

##### New Member
i have this column of numbers which is recorded every hour. i want to put a formula on the next column that converts the hourly data to 15 minute data, how will it be done?

ex

4 4
20 4
34 4
4
20
20
20
20
34
34
34
34

so in the next column four cells will have the same value then so on going down.

volt

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
or how to automatically put a formula in column B that will look like this

=A1
=A1
=A1
=A1
=A2
=A2
=A2
=A2
=A3
=A3
=A3
=A3
on so on
=

Replies
3
Views
424
Replies
2
Views
219
Replies
3
Views
478
Replies
0
Views
289
Replies
6
Views
596

1,196,155
Messages
6,013,763
Members
441,781
Latest member
Gian Carlos

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back