Creating number formula to count number occurences in a data set

G

Guest

Hello, I have a project where I am trying to take a data set (in this case
the GA Cash 3 lottery results) and use an Excel formula to count the number
of times a 3 digit number occurs in the dat ( example 318). Can anyone tell
me how to set this up? Or can anyone tell me what formula to use to count
the 3 digit numbers with the least occurences and the most occurences? I am
NOT using this to play the lottery rahter merely trying to complete an
assignment while learning to use formulas in Excel.

Thank you.
 

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 String occurences 4
Track Maximum occurences in Array 4
Count number of occurences in a list 12
Excel formula to count the number of records which contains a certaintext (wildcard) 3
count if two conditions in two arrays are true 1
Formula to count occurences of sickness 1
Count font colour in a cell 2
COUNT INBETWEEN A DATE RANGE 4

Top