I'm working on a stats spread sheet and I need to add a simple repeating list of sequential numbers to a column. For example:



In column A, I want to add 1 (94 times), 2 (94 times), 3 (94 times),.....726(94 times).
Could someone please direct me how to do this in an efficient way?

Thanks!

(1) =94*726*727/2 or

(2) =94*726*AVERAGE(1, 726) or

(3) =94*SUM(ROW(1:726))


(3) is an array formula so hold down Ctrl and Shift before pressing Enter.

It is always better to start a new thread when you have a new question ( adding a link to other threads if need be). Members ( working for free on their spare time) usually answer based on the thread title. So, if your new question is unrelated to the title you might miss some help.

I created a new thread for you this time

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post