ExcelBanter - i want to count how many times an entry occurs in an array

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - i want to count how many times an entry occurs in an array (https://www.excelbanter.com/excel-worksheet-functions/230546-i-want-count-how-many-times-entry-occurs-array.html)

jcb

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

Jacob Skaria

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

All times are GMT +1. The time now is 07:07 PM.