Random number

[vincen1211]

I hv 10x10 box (a1..j10) want to fill with random number 1-100
Any idea how to make function
Thanks b4

[Steel Monkey]

you could try:
=rand()

format the cells to suit

[arthurbr]

This link should get you started

[davegugg]

I'd go with =randbetween , then you could put in the top and bottom numbers.

[shg]

If you want random, non-repeating numbers from 1-100, you can use this function:

Please Login or Register  to view this content.

... and array-enter this formula in the 10x10 range:

=RandSeq()

[vincen1211]

@all thanks..
Special to arthurbr for link, teach me array-enter and shg for the function..

[shg]

Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

If more than two days have elapsed since your first post, ask a moderator to mark it.

[vincen1211]

Done, Thanks !!!