Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SLB
 
Posts: n/a
Default 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
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default


=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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Pivot Table combining multiple columns Pete Petersen Excel Discussion (Misc queries) 1 January 13th 05 08:56 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 07:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 09:13 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"