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)))
|