how to create a sorted summary list of counted species

P

pak

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
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a value from one column using an array and a single row 1
excel 2011 won't sort alphabetically 7
Count Num of Unique items in col ? 11
Shannon diversity index formula 9
how to create a sorted summary list of counted species 1
summing two columns of different data 4
Filtering a detailed list 5
Matching column criteria in a one to many relationship 8

Top