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?

how to create a sorted summary list of counted species
 

Check out help on Histogram and FREQUENCY Function.


Gord Dibben MS Excel MVP

On 20 Apr 2006 14:08:40 -0700, "pak" 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?