kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 951
- Office Version
- 365
Hi,
I have the following table:
In column M, I am trying to populate the code number repeatedly for the weeks based on the number of repeat frequency in cell O4. Since the repeat frequency is 2, the code is repeated twice for two weeks beginning with code 6 from cell P4. The correct result is shown in column M. Is there a way to use a formula to perform this where the result in column M changes according to the repeat frequency in cell and the beginning code in cell P4 ? Appreciate all the help.
I have the following table:
| Lifetime Planner_2024 v.1.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| K | L | M | N | O | P | |||
| 3 | Week Start | Week End | Code | Repeat Frequency | Start Code | |||
| 4 | 15-Jan-24 | 22-Jan-24 | 6 | 2 | 6 | |||
| 5 | 23-Jan-24 | 30-Jan-24 | 6 | |||||
| 6 | 31-Jan-24 | 7-Feb-24 | 7 | |||||
| 7 | 8-Feb-24 | 15-Feb-24 | 7 | |||||
| 8 | 16-Feb-24 | 23-Feb-24 | 8 | |||||
| 9 | 24-Feb-24 | 2-Mar-24 | 8 | |||||
| 10 | 3-Mar-24 | 10-Mar-24 | 9 | |||||
| 11 | 11-Mar-24 | 18-Mar-24 | 9 | |||||
| 12 | 19-Mar-24 | 26-Mar-24 | 10 | |||||
| 13 | 27-Mar-24 | 3-Apr-24 | 10 | |||||
| 14 | 4-Apr-24 | 11-Apr-24 | 11 | |||||
| 15 | 12-Apr-24 | 19-Apr-24 | 11 | |||||
SB | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| L4:L15 | L4 | =K4+7 |
| K5:K15 | K5 | =L4+1 |
In column M, I am trying to populate the code number repeatedly for the weeks based on the number of repeat frequency in cell O4. Since the repeat frequency is 2, the code is repeated twice for two weeks beginning with code 6 from cell P4. The correct result is shown in column M. Is there a way to use a formula to perform this where the result in column M changes according to the repeat frequency in cell and the beginning code in cell P4 ? Appreciate all the help.
