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
 

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

How to count the numbers in a Word document? 0
Creating a Search using a combo box and then creating a report. 4
Formula to find requested number 6
Is there a function to count how many times a cells value is used? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Count if equal to first non error cell 0
Count how many times a phrase comes up? 3

Top