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. |
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. |
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. |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com