View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark (plymouth) mark (plymouth) is offline
external usenet poster
 
Posts: 2
Default count number of instances a number occurs

Hi All,
i am trying, without success to creat a formula to do the following:
i have a series of values in a column and want to show how manay time a
number occurs within a range from the list.
i.e. in my list i have 12,17,23,24,25,23,24,22,26,43,32,32,33,44,53
i then want to display the number of instance there is an occurance of:
<10, 10-20, 21-30, 31-40, 41-50, 51
I would appreciate any assitance you might offer.

Thanks