Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare arrays | Excel Worksheet Functions | |||
Compare arrays | Excel Worksheet Functions | |||
how to compare two arrays? | Excel Programming | |||
Compare and update arrays | Excel Programming | |||
Arrays: compare fields? | Excel Programming |