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

I'll give you an example

A B C D
1 2 4 1 5 0...
2 5 1 2 4 0...
3 4

That is, if the 4 non repeated integers appear again in the second row,
then the function should return "1"

A B C D
1 2 4 1 5 0...
2 5 1 2 1 0...
3 4

In this case, the function should return "0" because not all the non
repeated integers appear just once in row #2.

I hope you can help