hi im wondering if there is an easier was of filling our rows of incremental data, but it needs to be for example ten cells of the same data, so for example
column b, rows 1-10, filled with 1
column b, rows 11-20 filled with 2
column b, rows 21-30 filled with 3
and so on
is there a function or formula i can use to apply this?
Bookmarks