setup offset in time periods in Excel

Q86. Our financial Year is divided into 13 periods of 4 weeks each. I enter weekly YTD data. In Excel, how can I set up Worksheet to get Period data automatically?

For example, how can I set up Col F to autopopulate based on values in Col C?

excel setup offset in time periods

To do it in Excel, here is the answer:

a) Consider cell C1 as reference. Every 4th value from reference has to be picked up from the Weekly YTD Sales column. This is a classic case of picking every nth row value in a column.

Enter the formula =OFFSET($C$1,(ROW(F2)-1)*4,0) as shown below for Period 1. Drag the formula all the way down for the remaining periods.

The second argument provides 4 row increments. The "-1" is introduced to account for the "YTD Sales" Title row.

excel excel setup offset in time periods

 

You can find similar Excel Questions and Answer hereunder

1) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

2) How can I hide Formula Bar and Headings using VBA?

3) Highlight row of selected cell in Excel

4) How to do date and time zone conversion in excel in Excel

5) How can I edit data in multiple WorkSheets together?

6) Split one long column into multiple smaller columns in Excel

7) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

8) I want a formula to concatenate multiple cell values separated by a line break.

9) How can I set up ListBox using VBA to allow users to select multiple values?

10) Is there a way I can convert between units of measurement in Excel?

11) How can I add a 3 Month Moving average Trend line to my line chart?

12) How can I enter a picture in a cell?

13) How can I add and link a Chart Title to a cell value?

14) I have a complex voluminous workbook with lot of formulas. Every time I make an update, the processing is slow. Any workarounds available?

15) Line break in vba message box in Excel