Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calc to show difference in numbers in two columns | Excel Discussion (Misc queries) | |||
How to stop calc using un-rounded data | New Users to Excel | |||
help with percentage of yes or no's | Excel Discussion (Misc queries) | |||
NETWORKDAYS calc with 3 columns of dates | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |