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

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
 
J

Jacob Skaria

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to find requested number 6
Find first occurence of a number in an array 7 cols wide 3
Count how many times a phrase comes up? 3
URGENT! how count how often a vlaue occurs within a range of value 3
Counting for frequency 2
Comparing the values in two cells, then counting how many differ 2
count for multiple conditions in multiple columns 2
count if equals first non error cell 6

Top