V
vsoler
My problem is as follows:
I have one set of integers and zeroes in A1:Z1 (26 cells)
Another set of integers and zeroes is in A2:Z2
I want to compare the first "n" numbers in A1:Z1 with the first "n"
numbers in A2:Z2; such "n" number is in A3 and may vary depending of
the scenario.
The first "n" integers in A1:Z1 contain no duplicates and no zeroes;
the first "n" integers in A2:Z2 may or may not have duplicates or
zeroes.
I need a formula that gives me "1" if the first "n" integers in A1:Z1
are exactly the same as the first "n" integers in A2:Z2, although they
may be in a different order; the formula would give zero in any other
case.
Can it be done by using one single formula?
Thank you for your help
I have one set of integers and zeroes in A1:Z1 (26 cells)
Another set of integers and zeroes is in A2:Z2
I want to compare the first "n" numbers in A1:Z1 with the first "n"
numbers in A2:Z2; such "n" number is in A3 and may vary depending of
the scenario.
The first "n" integers in A1:Z1 contain no duplicates and no zeroes;
the first "n" integers in A2:Z2 may or may not have duplicates or
zeroes.
I need a formula that gives me "1" if the first "n" integers in A1:Z1
are exactly the same as the first "n" integers in A2:Z2, although they
may be in a different order; the formula would give zero in any other
case.
Can it be done by using one single formula?
Thank you for your help