View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vsoler
 
Posts: n/a
Default Equivalence of two sets of data

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