Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create an automatic complete list from existing data in the sheet | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |