A
A
Alexey Mikhailov2021-07-29 01:07:17
Google Sheets
Alexey Mikhailov, 2021-07-29 01:07:17

How to make numbering with repetitions?

How to make in one cell (ARRAYFORMULA - ?) vertical numbering from 1 to 500, but so that each digit is repeated 5 times?

1
1
1
1
1
2
2
2
2
2
etc.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-07-29
@DPhil

=arrayformula(ОКРУГЛВВЕРХ((SEQUENCE(5*500))/5))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question