6 arrays in 6 worksheets compare

R

Rob

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top