|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2009, 02:20 AM
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
May 12th, 2009, 02:59 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
