Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a summary worksheet that references data in other sheets? | Excel Worksheet Functions | |||
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) |