The following VBA Macro generating repeated numbers.
Option 1 (which is preferred). Cells C1, D1 and E1 should show randomized Integer number between 0 and 9. Cells C1, D1 and D1 should NOT show same(repeated) numbers. This should continue all the way to Cells C1440, D1440 and E1440 where Cells C1440, D1440 and E1440 should NOT show same (repeated) numbers.
Alternatively, Option 2. Cell C1 should be a randomized number between 0 and 7. Cell D1 should be should show a randomized number between (greater than the value in Cell C1) and 8. Cell E1 should show a randomized number between (greater than the value in the Cell D1) and 9. This way it will not show any repeated numbers in any of the cells. This continue all the way to Cells C1440, D1440 and E1440 where Cells C1440,D1440 and E1440 should not repeated(same) numbers.
Your help will be greatly appreciated.
Thanks.
Bookmarks