Thread: Random Numbers
View Single Post
  #11  
Old September 10th, 2005, 05:56 AM
Harlan Grove
external usenet poster
  
Posts: n/a
Default
"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)))