Consolidate multiple entries in a row into average values

**GalahGirl** · 11-17-2011, 11:12 AM

Hello!

I have an Excel Spreadsheet (Mac 2011 version) with data about vegetation plots at different sites. Each site has up to three vegetation measurements in different categories, and I'm attaching an example of what the data looks like.

Each point (column A) has up to three subplots associated with it. I'd like to calculate an average and standard deviation for the measurements at each point - so site 1-2 will have three values to average, as will site 1-3, while site 1-4 will have two values to average and so on.

Is there a way to program this in Excel- to have Excel recognize that if values in column A are the same, calculate the average for all values in columns B and C and put them in a new column or sheet, with a revised column A that only has one row per site?

Thank you so much for your help, I really appreciate it.

Best,
Judith

**NBVC** · 11-17-2011, 11:58 AM

Perhaps a Pivot table?

http://office.microsoft.com/en-us/ex...010205886.aspx

**GalahGirl** · 11-17-2011, 01:01 PM

Thanks for the link to the tutorial, NBVC- I had tried a pivot table previously but couldn't get it to do what I wanted. It seems to work now. Appreciate it!