omp001
04-10-2018, 01:24 PM
Hi all. I need help to make a number sequence like below (red numbers), in any column. These numbers will be used with INDIRECT function.
row 1 ~~~> 1
row 2 ~~~> 2 (step =1 ~~~> row 1 + 1)
row 3 ~~~> 7 (step = 5 ~~~> row 2 + 5)
row 4 ~~~> 8 (step =1 ~~~> row 3 + 1)
row 5 ~~~> 13 (step = 5 ~~~> row 4 + 5)
row 6 ~~~> 14 (step =1 ~~~> row 5 + 1)
row 7 ~~~> 19 (step = 5 ~~~> row 6 + 5)
row 8 ~~~> 20 (step =1 ~~~> row 7 + 1)
...
...
...
Thanks in advance to all.
row 1 ~~~> 1
row 2 ~~~> 2 (step =1 ~~~> row 1 + 1)
row 3 ~~~> 7 (step = 5 ~~~> row 2 + 5)
row 4 ~~~> 8 (step =1 ~~~> row 3 + 1)
row 5 ~~~> 13 (step = 5 ~~~> row 4 + 5)
row 6 ~~~> 14 (step =1 ~~~> row 5 + 1)
row 7 ~~~> 19 (step = 5 ~~~> row 6 + 5)
row 8 ~~~> 20 (step =1 ~~~> row 7 + 1)
...
...
...
Thanks in advance to all.