Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi.
My spreadsheet has a repetitive calculation for each 25.th row. In another place I want to list up each of these values, but then in each and every row downwards. That is; A1 = 25 A26 = 26 A51 = 23 Now I want to copy these values to lets say to D1 like this D1 = 25 - Linked to A1 D2 = 26 - Linked to A26 D3 = 23 - Linked to A51 Is there a trick in the formula in D2 to automatically jump 25 rows from the row mentioned in D1, so it shows the value in A26, without me having to sit here day and night in a week to do the tedious copy and link jockey routine? -- regards Zadig Galbaras A Perturbed Norwegian Agnostic - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Copying Rows when hiding other rows | Excel Worksheet Functions |