for Excel experts

[yawar_hyatt2001]

hi,can anyone tell me how to solve this,
i have one row of nrs.
0 1 2 3 4 5 6 7 8 9
and in vertical column i have previous draw results i.e
256
764
297
903
784 etc
i want excel to show how many time each nr i.e from above row which contains nrs from o to 9,has been repeated ,
for this purpose what formula i should use,so that it can give me correct result i.e for nr 9 the result should be 2 and so on..thank in advance

 

[yawar_hyatt2001]

anyone there to answer my question

helllo...............can anyone tell me what is the answer to my question

 

[PAB]

Hi yawar_hyatt2001,

Assuming that the first set of numbers ( 0 to 9 ) are in cells A1:J1, put this formula in cell L1 and copy down :-

=COUNTIF($A1:$J1,0)

Change the 0 to whatever number you want to count.

Hope this Helps.
All the Best.
PAB

 

[yawar_hyatt2001]

@above

thanks PAB,but this didnt work,this command only counts repetation that has occured in particular column for example take following numbers 203,897,564,984.203 if i apply the count if command and define criteria 0 or 4 (0-9) it always give "1" value and on the contrary if define the criteria "203" it will return the value "2" which is true ,but this i dont want ,i want to have number of time a particular digit has appeared i.e from 0 - 9 in the above mentioned numbers for example if i want to count 2 it should return the following number 2 and for 0 it should give 2 and for 5 it should give 1 ...is there anyother command left for my query .???

 

[GillesD]

Counting digits in numbers

A quick way to do this would be to breakdown each individual 3-digit number into three columns each with a specific digit and then use the COUNTIF function to calculate the number of occurrences for each number (0 to 9).