FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,362
- Office Version
- 365
- 2016
- Platform
- Windows
Hello all,
In column A starting with A2, I would like to fill down with 1, 2, 3, 4, 5, 6, etc., but I would like to get random numbers between 3 and 8.
So, for example, see below. I will then fill in column B with dates. In the end, I will drag this down as far as today's date.
In column A starting with A2, I would like to fill down with 1, 2, 3, 4, 5, 6, etc., but I would like to get random numbers between 3 and 8.
So, for example, see below. I will then fill in column B with dates. In the end, I will drag this down as far as today's date.
Budget.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | Numbers | Date | ||
2 | 1 | 1-Jan-20 | ||
3 | 1 | 1-Jan-20 | ||
4 | 1 | 1-Jan-20 | ||
5 | 1 | 1-Jan-20 | ||
6 | 1 | 1-Jan-20 | ||
7 | 2 | 2-Jan-20 | ||
8 | 2 | 2-Jan-20 | ||
9 | 2 | 2-Jan-20 | ||
10 | 2 | 2-Jan-20 | ||
11 | 2 | 2-Jan-20 | ||
12 | 2 | 2-Jan-20 | ||
13 | 2 | 2-Jan-20 | ||
14 | 2 | 2-Jan-20 | ||
15 | 3 | 3-Jan-20 | ||
16 | 3 | 3-Jan-20 | ||
17 | 3 | 3-Jan-20 | ||
18 | 4 | 4-Jan-20 | ||
19 | 4 | 4-Jan-20 | ||
20 | 4 | 4-Jan-20 | ||
21 | 4 | 4-Jan-20 | ||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7:B21 | B7 | =IF(A6<>A7,MAX($B$6:B6)+1,B6) |