Value Increase/Decrease/No Change

M

Michael

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
 
K

Ken Wright

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

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

Similar Threads

Arriving at totals 2
Paragraph numbering in Word 1
Is there a shorten way to increase the value 1
Finding the right style field in VBA 0
If Function 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Need help with sorting and moving to worksheets 1
Match and delete rows on two different sheets from reference numbers 4

Top