Too many nested IF functions!
.... The numbers in C4:K4 are randomly 0 through 9, however sometimes
an error occurs and a duplicate number is inserted into the array.
I was wondering how these random numbers are being produced. It is not too
difficult to construct a macro that will produce nine numbers numbers with
no repeats... guaranteed.
Rick
|