View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Julia CHP Julia CHP is offline
external usenet poster
 
Posts: 1
Default Rounding up - number data and frequencies

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!