i want to count how many times an entry occurs in an array

  • Thread starter Thread starter JCB
  • Start date Start date
J

JCB

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
 
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
 
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
 
Back
Top