I am trying to generate a random number between 1-44 in colum B1 threw B44
but only want the numbers used once how do i do this.

Hi Dave,

Chip Pearson has an excellent way to do this, you might want to have a look
at he's site. Here is the link

http://www.cpearson.com/excel/RandomNumbers.aspx

Hope this helps you
--

Thank you and Regards

Garreth Lombard


"Dave try to get excel." wrote:

I am trying to generate a random number between 1-44 in colum B1 threw B44
but only want the numbers used once how do i do this.

We start by making a small table of values.

In H1 thru H44 enter 1 thru 44
In G1 thru G44 enter =RAND()

we see something like:

0.898741815 1
0.473298735 2
0.841648007 3
0.197630486 4
0.93517653 5
0.275864629 6
0.929841572 7
0.545708818 8
0.759334999 9
0.576480857 10
0.693499289 11
0.544970694 12
0.422273909 13
0.574371466 14
0.833157067 15
0.262129694 16
0.68497402 17
0.578225504 18
0.008816299 19
0.936929428 20
0.632992474 21
0.103106258 22
0.634808689 23
0.383647926 24
0.592741451 25
0.034319324 26
0.845101219 27
0.858571656 28
0.292890124 29
0.770439698 30
0.781950898 31
0.228762659 32
0.256030041 33
0.481113534 34
0.870945576 35
0.337407228 36
0.432227345 37
0.957544666 38
0.478646674 39
0.313322922 40
0.757481734 41
0.548400077 42
0.651435747 43
0.621873707 44

In B1 we enter:

=VLOOKUP(LARGE(G$1:G$44,ROW()),G$1:H$44,2,FALSE)
and copy down thru B44
--
Gary''s Student - gsnu201001


"Dave try to get excel." wrote:

I am trying to generate a random number between 1-44 in colum B1 threw B44
but only want the numbers used once how do i do this.