Formula, take 1 row/column and creating more rows that subtract 1 till desired

[wonka1234]

Hi,

Say I have the value of:

Period Remaining

78

and I want to create:

Period Remaning
78
77
76
75
74
73
72
71
70
69
68
67
66
65
64
63
62
61
60
59
58
57
56
55
54
53
52
51
50
49
48
47
46
45
44
43
42
41
40
39
38
37
36
35
34
33
32
31
30
29
28
27
26
25
24
23
22
21
20
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
0
-1
-2
-3
-4
-5
-6
-7
-8
-9
-10
-11
-12
-13
-14
-15
-16

for 95 rows. 

Is this possible to do?

Thanks.

[chukleswk · Accepted solution]

Yes, you can use the Generate Rows tool to do this: