6 arrays in 6 worksheets compare
 

Trying to compare 6 arrays in 6 worksheets. same file
Trying use the following equation.

=SUMPRODUCT(--(A1<$A$1:$A$7),1/COUNTIF($A$1:$A$7,$A$1:$A$7&""))+1
worksheet 1
data result
A B
1 6
2 5
3 4
4 3
4 2
7 1
7 1
Theses results are for 1 worksheet, however I would like to comapre the same
row in 6 worksheets. And get the results based on all 6 arrays.
thanks Rob

6 arrays in 6 worksheets compare
 

Still hopeing for help!
Thanks in advance
Rob


"Rob" wrote:

Trying to compare 6 arrays in 6 worksheets. same file
Trying use the following equation.

=SUMPRODUCT(--(A1<$A$1:$A$7),1/COUNTIF($A$1:$A$7,$A$1:$A$7&""))+1
worksheet 1
data result
A B
1 6
2 5
3 4
4 3
4 2
7 1
7 1
Theses results are for 1 worksheet, however I would like to comapre the same
row in 6 worksheets. And get the results based on all 6 arrays.
thanks Rob