Setup offset in time periods in Excel
For example, how can I set up Col F to autopopulate based on values in Col C?
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.
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