List Reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Menu>List>Create
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.
 
Back
Top