| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating number formula to count number occurences in a data set
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. -- Brreese24 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating number formula to count number occurences in a data set
if the data is in column A:
=COUNTIF(A:A, 318) -- Gary''s Student - gsnu200739 "Brreese24" wrote: 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. -- Brreese24 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences in a list | Excel Worksheet Functions | |||
| how to count the number of occurences of a letter ? | Excel Discussion (Misc queries) | |||
| How to count number of occurences of two different things at once? | Excel Worksheet Functions | |||
| count number of occurences on a particular date | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Linear Mode
