List Reference
 

I have created a list of numbers.... let's say from 0 to 1000

this list is coming from a database of information.
I want to find out how many numbers are available in certain intervals
0-35, 35-55, 55-75, 75-95, and then the intervals increase in size after 300.

I have an excel list holding this data.... (from the Data MenuListCreate
List)

now it is easy to use the custom feature with the filter of the list to get
it to show the numbers in a certain range. then count the numbers in each
range and put the info in a separate table

What i would like to do and i am not sure if this is possible, is create a
reference
to the custom filter of the list
for example

Range Count
------- -------
0-35 =count(list.customrange(0<x<35)
35-55 =count(list.customrange(35<x<55)

and so forth and so on...

I do not know if you can use a list reference in a count function and i do
not know if there is such a reference. Any help would be appreciated.

List Reference
 

Look at the Bin function in the Excel help.

RBS

"Sam" wrote in message
...
I have created a list of numbers.... let's say from 0 to 1000

this list is coming from a database of information.
I want to find out how many numbers are available in certain intervals
0-35, 35-55, 55-75, 75-95, and then the intervals increase in size after
300.

I have an excel list holding this data.... (from the Data MenuListCreate
List)

now it is easy to use the custom feature with the filter of the list to
get
it to show the numbers in a certain range. then count the numbers in each
range and put the info in a separate table

What i would like to do and i am not sure if this is possible, is create a
reference
to the custom filter of the list
for example

Range Count
------- -------
0-35 =count(list.customrange(0<x<35)
35-55 =count(list.customrange(35<x<55)

and so forth and so on...

I do not know if you can use a list reference in a count function and i do
not know if there is such a reference. Any help would be appreciated.

List Reference
 

Excel Help is not returning any information on a "Bin Function"

"RB Smissaert" wrote:

Look at the Bin function in the Excel help.

RBS

"Sam" wrote in message
...
I have created a list of numbers.... let's say from 0 to 1000

this list is coming from a database of information.
I want to find out how many numbers are available in certain intervals
0-35, 35-55, 55-75, 75-95, and then the intervals increase in size after
300.

I have an excel list holding this data.... (from the Data MenuListCreate
List)

now it is easy to use the custom feature with the filter of the list to
get
it to show the numbers in a certain range. then count the numbers in each
range and put the info in a separate table

What i would like to do and i am not sure if this is possible, is create a
reference
to the custom filter of the list
for example

Range Count
------- -------
0-35 =count(list.customrange(0<x<35)
35-55 =count(list.customrange(35<x<55)

and so forth and so on...

I do not know if you can use a list reference in a count function and i do
not know if there is such a reference. Any help would be appreciated.

List Reference
 

Yes, you are right. Look at the Frequency function.

RBS

"Sam" wrote in message
...
Excel Help is not returning any information on a "Bin Function"

"RB Smissaert" wrote:

Look at the Bin function in the Excel help.

RBS

"Sam" wrote in message
...
I have created a list of numbers.... let's say from 0 to 1000

this list is coming from a database of information.
I want to find out how many numbers are available in certain intervals
0-35, 35-55, 55-75, 75-95, and then the intervals increase in size
after
300.

I have an excel list holding this data.... (from the Data
MenuListCreate
List)

now it is easy to use the custom feature with the filter of the list to
get
it to show the numbers in a certain range. then count the numbers in
each
range and put the info in a separate table

What i would like to do and i am not sure if this is possible, is
create a
reference
to the custom filter of the list
for example

Range Count
------- -------
0-35 =count(list.customrange(0<x<35)
35-55 =count(list.customrange(35<x<55)

and so forth and so on...

I do not know if you can use a list reference in a count function and i
do
not know if there is such a reference. Any help would be appreciated.