with random No's calc how can I stop two different columns predic.
 

I have used the Randbetween calculation in four columns, however on a few
occasions the same number is predicted in two different columns, how can I
overcome this problem

with random No's calc how can I stop two different columns predic.
 

Randbetween does not generate unique random numbers. Just random numbers.

the solution would be to write you own routine to generate unique random
numbers or query Google for posts in this group where such code has been
produced many times.

http://groups-beta.google.com/advanced_search

--
Regards,
Tom Ogilvy


"Excel Problems" <Excel wrote in message
...
I have used the Randbetween calculation in four columns, however on a few
occasions the same number is predicted in two different columns, how can I
overcome this problem

with random No's calc how can I stop two different columns predic.
 

It is the nature of a random number: if it is random, there is a random
chance of a match with another number. A simple way to deal with this is to
just recalculate the specific cells that repeat until you eliminate any
matches. There are more sophisticated ways but they would involve complex
coding.
--
- K Dales


"Excel Problems" wrote:

I have used the Randbetween calculation in four columns, however on a few
occasions the same number is predicted in two different columns, how can I
overcome this problem

with random No's calc how can I stop two different columns predic.
 

For ideas that *I* like (and you will find more if you follow Tom's
suggestion {grin}) see
Random Selection
http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?RXhjZWwgUHJvYmxlbXM=?=" <Excel
says...
I have used the Randbetween calculation in four columns, however on a few
occasions the same number is predicted in two different columns, how can I
overcome this problem

with random No's calc how can I stop two different columns pre
 

Tom,
Many thyanks but you sugest writting my own routine, can you provide example
of a routine please

thanking you in anticipation regards

Bernie

"Tom Ogilvy" wrote:

Randbetween does not generate unique random numbers. Just random numbers.

the solution would be to write you own routine to generate unique random
numbers or query Google for posts in this group where such code has been
produced many times.

http://groups-beta.google.com/advanced_search

--
Regards,
Tom Ogilvy


"Excel Problems" <Excel wrote in message
...
I have used the Randbetween calculation in four columns, however on a few
occasions the same number is predicted in two different columns, how can I
overcome this problem

with random No's calc how can I stop two different columns pre
 

Tushar provided a great link:

http://www.tushar-mehta.com/excel/ne...ction/vba.html

--
Regards,
Tom Ogilvy

"Excel Problems" wrote in message
...
Tom,
Many thyanks but you sugest writting my own routine, can you provide
example
of a routine please

thanking you in anticipation regards

Bernie

"Tom Ogilvy" wrote:

Randbetween does not generate unique random numbers. Just random
numbers.

the solution would be to write you own routine to generate unique random
numbers or query Google for posts in this group where such code has been
produced many times.

http://groups-beta.google.com/advanced_search

--
Regards,
Tom Ogilvy


"Excel Problems" <Excel wrote in
message
...
I have used the Randbetween calculation in four columns, however on a
few
occasions the same number is predicted in two different columns, how
can I
overcome this problem