ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   From single cell variables to a single column serie (https://www.excelbanter.com/new-users-excel/123539-single-cell-variables-single-column-serie.html)

noyau

From single cell variables to a single column serie
 
I'm after to form a "single column serie" using manually enetered (or
automatically changed) values in a "single cell". Lets say that the value in
A1 is changed daily and each value is written to the next row, so I have
A2:A32 serie for values from A1 in December

trial variable (serie progression)
(date) (values from A1)
1 23 23 23 23 23
2 24 24 24 24
3 32 32 32
4 19 19
(and so on)


All my best and happy new years....

noyau

From single cell variables to a single column serie
 


The idea is more clearly and simply to "freeze" the variables of a single
cell somewhere else.


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com