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

Use Histogram tool available under Tools/Data Analysis. For this you need to
have the following AddIn installed.

Analysis Toolpak

So if you do not see that option, first go to AddIns and check the Analysis
Toolpak addin and then you should be able to see the option.

Alok

"Walker" wrote:


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

Thanks very much!!!


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