Not sure it makes any difference.
In A1:A22 I have 12, 12.1, 12.2 ....13.9,14
In my bin (C1:C3) I have 12,13,and 14
The formula =FREQUENCY(A1:A21,$C$1:$C$3) gives the counts 1, 10,10
In B1 I have =ROUNDUP(A1,0) and this is copied down to B22 giving 12,
13,13,13,13,13,13,13,13,13,13,14,14,14,14,14.14.14 .14.14.14
The formula =FREQUENCY(B1:B21,$C$1:$C$3) gives the same counts 1, 10,10
Or have I missed the point?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Julia CHP" wrote in message
...
Hi-
I am trying to capture the frequencies of a data set of numbers. The
numbers
were recorded with one decimal point, and I am only trying to capture
whole
numbers.
I have 11,300 records, and I would like to avoid manually rounding these
numbers to the nearest whole number, but I need an accurate frequency
count.
How can I round up these numbers and count them specifically? (Rather than
count the original data set that contains something similar to 13.1, 13.2,
13.2, 13.6, 13.8, etc.)
Thanks!