Very specific question on tables

How can I assemble some non-repeating data?

For example:

Column 1 has 1,2,3,5,6,7,8
Column 2 has 1,2,4,6,7,8,9
Column 3 has 2,4,5,6,7,8,9

I would like to pull out a random value from each column, without repeats.
success: 1,2,8
fail: 2,6,2

So, when I pull out values from column 2 and 3, and need to do some kind of filter on them to make sure the data I pulled out already does not match.

Can anyone point me in the right direction?

Thanks!

Answers

Sign In or Register to comment.