Thread: i want to count how many times an entry occurs in an array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default i want to count how many times an entry occurs in an array
It would be helpful if you explain bit more about how your data is arranged.
Assuming you have the numbers in Col A and you want to know how many times
the numbers are there.

=COUNTIF(A:A,12345678)

If this post helps click Yes
---------------
Jacob Skaria


"JCB" wrote:

i am trying to count how many times a number has occured in the last 52 draws
of the lotto ( 6 numbrs + two supplementry numbers
Reply With QuoteReply With Quote