vicktor schausberger
Member
Hi everyone.
I am studying the Random behave of a large numbers so the best real life example is on gambling.
I am looking compare a sets of 6 numbers, so I want to be sure that I don’t have any set
Equal or duplicates in the array located at sheet 2
Example
If I have in the sheet 2 in a row, the number 15 / 17 / 30 / 42 / 44 / 49 / I don’t want this
specific number or row, to be duplicate, in the others array that I have; reason why I remark about row by row,
in other way nothing here is about columns, it is only the 6 numbers by row.
The samples array I have they are Dynamics
Sheet 2 array one. SIZE at this moment is [L2:Q46] this is the array need to be unique.
And array two size at this moment is [S2:X46]
Compare SHEET 2 AGAINST 3 to find duplicates
SHEET 3 SIZE at this moment is (R1:W2577)
START
SHEET2 row(L2:Q2) against [sheet3 (R1:W1)]
IF row L2:Q2 = R1:W1 then
Highlight –Sheet2 ROW L2:Q2
DO the same until find the last row on both arrays
END
NEXT
compare SHEET 2 AGAINST 5 to find duplicates
SHEET5 size at this moment is (B2:G2578)
START
Sheet2 row(L2:Q2) against [sheet5 (B2:G2)]
IF row L2:Q2 = B2:G2 then
Highlight –Sheet2 ROW L2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
NEXT
SHEET10 size at this moment is(R1:W1448)
START
Sheet2 row(L2:Q2) against [sheet10 (R1:W1)]
IF row L2:Q2 = R1:W1 then
Highlight –Sheet2 ROW L2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
NEXT
SHEET4 size at this moment is (K22578)
START
Sheet2 row(S2:X2) against [sheet4 (K22)]
IF row S2:X2 = K22 then
Highlight –Sheet2 ROW S2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
Thank you for the time you expended reading this,
I am studying the Random behave of a large numbers so the best real life example is on gambling.
I am looking compare a sets of 6 numbers, so I want to be sure that I don’t have any set
Equal or duplicates in the array located at sheet 2
Example
If I have in the sheet 2 in a row, the number 15 / 17 / 30 / 42 / 44 / 49 / I don’t want this
specific number or row, to be duplicate, in the others array that I have; reason why I remark about row by row,
in other way nothing here is about columns, it is only the 6 numbers by row.
The samples array I have they are Dynamics
Sheet 2 array one. SIZE at this moment is [L2:Q46] this is the array need to be unique.
And array two size at this moment is [S2:X46]
Compare SHEET 2 AGAINST 3 to find duplicates
SHEET 3 SIZE at this moment is (R1:W2577)
START
SHEET2 row(L2:Q2) against [sheet3 (R1:W1)]
IF row L2:Q2 = R1:W1 then
Highlight –Sheet2 ROW L2:Q2
DO the same until find the last row on both arrays
END
NEXT
compare SHEET 2 AGAINST 5 to find duplicates
SHEET5 size at this moment is (B2:G2578)
START
Sheet2 row(L2:Q2) against [sheet5 (B2:G2)]
IF row L2:Q2 = B2:G2 then
Highlight –Sheet2 ROW L2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
NEXT
SHEET10 size at this moment is(R1:W1448)
START
Sheet2 row(L2:Q2) against [sheet10 (R1:W1)]
IF row L2:Q2 = R1:W1 then
Highlight –Sheet2 ROW L2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
NEXT
SHEET4 size at this moment is (K22578)
START
Sheet2 row(S2:X2) against [sheet4 (K22)]
IF row S2:X2 = K22 then
Highlight –Sheet2 ROW S2:Q2
If already highlight then next
DO the same until find the last row on both arrays
END
Thank you for the time you expended reading this,