Value Increase/Decrease/No Change
 

Hi Folks - Assume I have a table of date:

FirstScore SecondScore
6 7
7 7
4 3
8 4
9 9
4 2
5 5
2 8

What is the best technique for determining the counts for an increasing
value, a decreasing value, and no change between the first score and the
second score?

In this case, it would be:

Increased 2
Decreased 3
No Change 3

Thanks.

Michael

=SUMPRODUCT(--((B2:B9)(A2:A9)))
=SUMPRODUCT(--((B2:B9)<(A2:A9)))
=SUMPRODUCT(--((B2:B9)=(A2:A9)))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Michael" wrote in message
news:k6Jid.2987$rG2.2843@lakeread05...
Hi Folks - Assume I have a table of date:

FirstScore SecondScore
6 7
7 7
4 3
8 4
9 9
4 2
5 5
2 8

What is the best technique for determining the counts for an increasing
value, a decreasing value, and no change between the first score and the
second score?

In this case, it would be:

Increased 2
Decreased 3
No Change 3

Thanks.

Michael





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004