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

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
>
>