how to create a sorted summary list of counted species

Here's what I have:

An array of bird counts. 4 (yearly) sheets with bird counts. The
first column is the list of species, the second column is the sum of
the remaining columns, the successive columns are the counts for each
species for that day.

So,

species,sum,number,number,number,...

What I want to do, in a separate sheet, is to create a table of all the
species that have totals within a range.

Basically I want to end up with:

>1000 >900 >800 >700 >600 >50
species species species species species species
species species species species
species

The above numbers are just an example. It would really be an added
bonus if the lists of species in a range were sorted by their
abundance.

Any ideas as to how to go about this?

Check out help on Histogram and FREQUENCY Function.


Gord Dibben MS Excel MVP

On 20 Apr 2006 14:08:40 -0700, "pak" <kellerp.l@gmail.com> wrote:

>Here's what I have:
>
>An array of bird counts. 4 (yearly) sheets with bird counts. The
>first column is the list of species, the second column is the sum of
>the remaining columns, the successive columns are the counts for each
>species for that day.
>
>So,
>
>species,sum,number,number,number,...
>
>What I want to do, in a separate sheet, is to create a table of all the
>species that have totals within a range.
>
>Basically I want to end up with:
>
>>1000 >900 >800 >700 >600 >50
>species species species species species species
>species species species species
> species
>
>The above numbers are just an example. It would really be an added
>bonus if the lists of species in a range were sorted by their
>abundance.
>
>Any ideas as to how to go about this?