View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimbob jimbob is offline
external usenet poster
 
Posts: 1
Default Related to "Counting cells..." (post below)


I have a range of cells with values that range from (approx) .3 to 2.5.
There are about 4600 cells with data. Is there a way to caluculate how
prevalent each number is with, say a range of .5? In other words, I
want to calculate how often a value of greater than .5 and less than
1.0 occurs. Or greater than 0, but less than.5 and so on.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=558202