loop to add

[aquinlan]

hello all,

I would like to know is there an easier way to do this.See attached for a dummy example.
i want to pick 4 random numbers from the list and add them together.i have it done in the attached but is it possible to put into a loop that would make the code better.thanks

[Richard Buttrey]

Hi,

Another way is as follows. Keep a helper column G adjacent to F and in G1 copied down enter =RAND()
Now with a macro

Please Login or Register  to view this content.

HTH

[aquinlan]

Thanks richard,

Is there any way you can think rather than using a helper column.All i was hoping for was to use a simple loop.

[Leith Ross]

Hello aquinlan,

Is this what you were looking for?

Please Login or Register  to view this content.

[aquinlan]

leith ross thats exactly what i was after.thank you very much.
and also again to richard thank you for your help.