Testing Array's

[djblois1]

I want to be able to test a Range to see if it is equal to an array:

Please Login or Register  to view this content.

three different ways I would like to test it:

1) I want to test if it is exactly the same including if it is in the same order

2) I want to test if it is the same but in a different order

3) I want to be able to test of the range is included within that array but it is not complete.

[djblois1]

anyone have any ideas?

[Kyle123]

This should do 1 & 2, I don't understand 3

Please Login or Register  to view this content.

[romperstomper]

I would think that adding a check for the same dimensions to those two tests would cover it.

[snb]

to test the match:

if the range is A7:AR7

check whether they are identical:

Please Login or Register  to view this content.

check if they are the same but in different order

Please Login or Register  to view this content.

check whether the array is part of the range:

Please Login or Register  to view this content.