Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same values to several cells
I am using Excel 2003 to do some temperature modelling. I have a long list of
daily average temperature. I want to create a new list where the each day is divided into periods of 6 hours and each cell is linked to the belonging daily average temperature. In my new list I want to connect the first five cells to the first cell in old list, then connect the next five cells to the second cell in the old list and so on. Since I am working with 10000 of data I need to find a method that can be copied down the coulomm. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same values to several cells
Say the old list is on Sheet1, Column A.
Enter this anywhere in Sheet2, and copy down as needed, to start your new list: =INDEX(Sheet1!A:A,(ROWS($1:1)+4)/5) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Joe Holgersen" wrote in message ... I am using Excel 2003 to do some temperature modelling. I have a long list of daily average temperature. I want to create a new list where the each day is divided into periods of 6 hours and each cell is linked to the belonging daily average temperature. In my new list I want to connect the first five cells to the first cell in old list, then connect the next five cells to the second cell in the old list and so on. Since I am working with 10000 of data I need to find a method that can be copied down the coulomm. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same values to several cells
Joe,
If your old list is in A2:A10000: =INDEX($A$2:$A$10000,(ROW(A1)-1)/5+1) and copy that down... HTH, Bernie MS Excel MVP "Joe Holgersen" wrote in message ... I am using Excel 2003 to do some temperature modelling. I have a long list of daily average temperature. I want to create a new list where the each day is divided into periods of 6 hours and each cell is linked to the belonging daily average temperature. In my new list I want to connect the first five cells to the first cell in old list, then connect the next five cells to the second cell in the old list and so on. Since I am working with 10000 of data I need to find a method that can be copied down the coulomm. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
find the max values for cells in consecutive groups of 600 | Excel Discussion (Misc queries) | |||
How to only "paste values" of cells that are not "hidden"? | Excel Discussion (Misc queries) | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |