Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Table of Value Ranges
3 views
Skip to first unread message
mvk
Feb 25, 2008, 4:05:10 PM2/25/08
to
The countif function will do this. I have posted an example at
www.tejniya.co.uk, under documents and excel.
www.tejniya.co.uk, under documents and excel.
Manish
"$cruncher" <crun...@discussions.microsoft.com> wrote in message
news:8180BF7F-049E-4C7C...@microsoft.com...
> What function can I use to analyze numerical data in a column and return
> the
> number of items into a table showing ranges of values? Such as X no. of
> items in value range $600 to $1,000; X no. of items in value range $1001
> to
> $2,000, etc. Thanks!
> --
> $cruncher
0 new messages