Quote (criminal101 @ Wed, Jan 14 2009, 06:37pm)
so i have a list of numbers, i want to count how many instances of every range of a number exist
ie:
1,1,2,3,4,
x2 1
x1 2
x1 3
x1 4
any one know how to do this?
seem to be having trouble with the frequency command its seems to count every integer below the selected range ie if i say count all
2's from the example above it will count 3 since 2>1 rather than 1 since only one 2 exist
=FREQUENCY($A$1:$A$100,b1)
current command i am using b's are 1-100 a's are random numbers
=COUNTIF(A1:A100,1)