Hey All,

I was trying to find a way to count occurences for multipl
criteria. Here is the situation: I have 200 6-digit numbers in eac
cell with a range from A1:A200, i.e A1 has 200 6-digit numbers and s
does A2, A3...A200. I want to find the number of times a Value in B
occurs in A1:A200. But the value in B1 should correspond to a Text i
C1, and count the number of times the text occurs from a range o
C1:C200. Let me give you an example. A1=(234789 265789 98756
436278.......) all the way to A200, which has 200 6 digit numbers. Now
the value in B1=436278 and the Value associated with B1 is C1=Texas.
would like to find an efficient way of counting the number of times
value in B1=C1 occurs in A1:A200. I know this is a big question, bu
please help. Thanks

--
Toma
-----------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...fo&userid=3155
View this thread: http://www.excelforum.com/showthread.php?threadid=51320