LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create an automatic complete list from existing data in the sheet Etienne Excel Discussion (Misc queries) 2 February 8th 06 01:55 PM
How do I create a List in Excel 2000 Watch Online Excel Worksheet Functions 1 January 31st 06 07:45 PM
Trying to Create a Conditional Drop down list Noel Excel Worksheet Functions 6 July 26th 05 05:18 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 07:57 PM
How do you create a drop down list? Aviator Excel Discussion (Misc queries) 2 December 28th 04 03:07 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"