PC Review


Reply
Thread Tools Rate Thread

6 arrays in 6 worksheets compare

 
 
Rob
Guest
Posts: n/a
 
      15th Apr 2009
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 With Quote
 
 
 
 
Rob
Guest
Posts: n/a
 
      16th Apr 2009
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare two arrays Greg Snidow Microsoft Excel Programming 5 1st Dec 2009 03:34 AM
Compare Rows on different Worksheets and Output Difference's to other Worksheets. dids72@gmail.com Microsoft Excel Programming 3 19th Sep 2007 04:48 PM
Compare arrays =?Utf-8?B?eW91bmdzdGVy?= Microsoft Excel Worksheet Functions 3 31st Jul 2007 04:36 PM
Compare 2 arrays ? Jim Andersen Microsoft ASP .NET 4 18th Aug 2006 03:29 PM
Compare Arrays Turbot Microsoft VB .NET 8 23rd Nov 2004 02:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:54 PM.