Prev: Modify general format to date format.
Next: Index using a defined name array
From: David Heaton on 27 Apr 2010 01:31
On Apr 27, 5:09 am, LadyK974 <LadyK...(a)discussions.microsoft.com>
wrote:
> in a spreadsheet i have a range of numbers that needed to be counted ie.  
> phos levels between 3.5-5.5  I can't find a formula to support this. Can you
> help

Maybe have a look at the frequency formula.

It takes the range of values you have then a range of bins (interval
values, 2.5,3,3.5,4,4.5, etc) and returns the number of values that
fall within each bin

Regards

David
 | 
Pages: 1
Prev: Modify general format to date format.
Next: Index using a defined name array