No Repetition RAND and converting text to cell reference

  • Thread starter Thread starter StumpD
  • Start date Start date
S

StumpD

I've got two days to Submit this problem on my exam...

Randomly generate six numbers, and none of the digits must be
alike.

For example:

9 9 1 0 2 3

NO

9 0 1 4 5 2

YES


Also, a program that will have the user define the row and the column
and will retrieve the contents of the combined text:

Example:

On A1, I type 1
On A2, I type J
On A3, Machine will type contents of "IJ"


Whoever will solve this I will be eternally grateful.

Pleez.

P.S. An added catch is that it's only Excel Functions. You can't us
VB
 
Back
Top