I've spent the last 2 days trying to come up with a formula that will produce a list of decreasing numbers with each number being repeated a diminishing number of times.
For example...
7
7
7
7
7
7
7
6
6
6
6
6
6
5
5
5
5
5
4
4
4
4
3
3
3
2
2
1
The starting number (n) will vary, but the initial number of repetitions will always be n.
This is the closest that I've come so far.
=INT((ROWS($AM$38:AM38)-1)/($I$49-INT((ROWS($AM$38:AM38)-1)/$I$49)))
Where I49 is the initial number (n). It works for the first set of repetitions, but fails quickly thereafter.
Thanks in advance,
Brent
Bookmarks