Count certain changes between columns
 

I have 2 columns that use the numbers 1-100 as various location codes. One
column has the original data and the other has the new data. If there were
changes made, then the second column has a different code, otherwise the
codes stayed the same in both columns.
I have already posted a question to find out how to count how many changes
there are total but now I need to know how many cahnges were made from just a
certain group of numbers to just another certain group of numbers (as opposed
to changes being made within the same group).
EXAMPLE:
I need to know if the numbers 1-15 and 60-89 ever changed to 16-39
COLUMN A CLOMUN B
1 25 ----- This needs to be counted
10 11
60 60
72 75
15 39 ----- And this needs to be counted
63 63

Please let me know if you have any ideas of how I can do this!

Thanks,
sophia

=SUMPRODUCT(($A$2:$A$7=1)*($A$2:$A$7<=15)+($A$2:$ A$7=60)*($A$2:$A$7<=89),--($B$2:$B$7=16)*($B$2:$B$7<=39))

SLB Wrote:
I have 2 columns that use the numbers 1-100 as various location codes.
One
column has the original data and the other has the new data. If there
were
changes made, then the second column has a different code, otherwise
the
codes stayed the same in both columns.
I have already posted a question to find out how to count how many
changes
there are total but now I need to know how many cahnges were made from
just a
certain group of numbers to just another certain group of numbers (as
opposed
to changes being made within the same group).
EXAMPLE:
I need to know if the numbers 1-15 and 60-89 ever changed to 16-39
COLUMN A CLOMUN B
1 25 ----- This needs to be counted
10 11
60 60
72 75
15 39 ----- And this needs to be counted
63 63

Please let me know if you have any ideas of how I can do this!

Thanks,
sophia


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274323