| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to count how many times an entry occurs in an array
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i want to count how many times an entry occurs in an array
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 --------------- Jacob Skaria "JCB" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count no. of times a character occurs in a cell | Excel Worksheet Functions | |||
| I want to see how many times each number occurs in an array. | Excel Discussion (Misc queries) | |||
| I would like to count the # of times a value occurs in Col B base | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
Hybrid Mode
