I will try to make this as short as possible! Here is the situation. I
need to count "incidences" based on particular criteria in a spreadsheet
that contains up to 50,000 rows in order to creat a series for graphing.


Starting in the middle, I wish to count the number of times a
particular vaule falls between -2.5 and 2.5. Moving out in either
directions, I wish to count the number of incidences in increments of 5
in order fo populate a table with associated counts for each of the
following:
<-102.5
Between -97.5 and -102.5 (-102.5 AND <-97.5)
Between -92.5 and -97.5 (-97.5 AND <-92.5)
Between etc

to the positive end of the range. Essentially I need counts of teh
nember of times a cell in a range falls within +/- 2.5 of the following
midpoints: -100+/-95/-90/-85...0...5/10/15...100+

Thanks!


--
Walker
------------------------------------------------------------------------
Walker's Profile: http://www.excelforum.com/member.php...o&userid=28037
View this thread: http://www.excelforum.com/showthread...hreadid=475454