Setup offset in time periods in Excel

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 setup offset in time periods


You can find similar Excel Questions and Answer hereunder

1) How to protect your worksheet from changes in Excel

2) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

3) How do I know which cells on the worksheet contain Conditional Formatting?

4) Various important math functions in VBA (trigonometry, algebra, exponential, )

5) How to print a worksheet in Excel VBA

6) How do I find the median salary of employees with the same skillset in my Organization?

7) How can I set up a dynamic named range that expands automatically when new items are added to the list?

8) How do i apply a formula to an entire column in Excel

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

10) How to read a value from a cell in vba in Excel


Here the previous and next chapter