Home |
Search |
Today's Posts |
#9
|
|||
|
|||
Hello Harlan from Steved
Harlan done as discribed below but still have the issue offsame number twice omn the same line in this case row 8 i've 13 twice and row 10 I have 24 twice. Is it possible please to have this issue where their are no doubles. Thankyou for your patience. "Harlan Grove" wrote: "Steved" wrote... .... =COUNTIF(PRNA,"<="&TRANSPOSE(OFFSET(PRNA,INT(35*R AND()),0,6,1))) .... Sorry, I screwed this up. Swap the 6 and 1 arguments, so =COUNTIF(PRNA,"<="&TRANSPOSE(OFFSET(PRNA,INT(35*RA ND()),0,1,6))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions |