Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change a formula | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |