I have the data sorted now, but I've run into another two stumbling
blocks. I want to calculate averages for subgroups of rows.

I changed the column headers to species rank numbers and deleted the
extra colmns (of 155 species, the most seen in any given plot was just
17). I want to calculate the average of each rank category (1 - 17) for
each site x season combination. Pivot table wants to make my columns
into rows. It also doesn't put the site and seaon data in each row. It
has the site name on one row and then all rows from that site follow,
but don't have the right data. I need the data to look like this for
importation into SYSTAT:

Site Season Year Rank Abundance
Site_A Spring 2003 1 35%
Site_A Spring 2003 2 25%
Site_A Spring 2003 3 5%
Site_A Fall 2003 1 45%
Site_A Fall 2003 2 35%

Where the abundance is the mean for that particular rank x season x
year combination.


--
guillemot
------------------------------------------------------------------------
guillemot's Profile: http://www.excelforum.com/member.php...o&userid=29833
View this thread: http://www.excelforum.com/showthread...hreadid=495747