View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomac Tomac is offline
external usenet poster
 
Posts: 1
Default Counting Occurences


Hey Everybody,

I am wondering if anybody can help me out with
this. I need to find a way to count occurences in a cell, and the
COUNTIF function will not work this is why: Every cell has more 200
6-digit numbers in it. For example cell A1 will have 200 6-digit
numbers. Like this every cell till A1000 has 6-digit numbers. Now i
have *ONE* 6-digit number in cells B1 to B1000. I would like to know if
there is a way to count the number of times a 6-digit number in B1 would
occur in a range from cell A1 to A1000. But here is the catch, all the A
cells have 200 6-digit numbers. I have been really breaking my head on
this. Please help.


--
Tomac
------------------------------------------------------------------------
Tomac's Profile: http://www.excelforum.com/member.php...o&userid=31555
View this thread: http://www.excelforum.com/showthread...hreadid=512494