View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default How can I average data from a repeating list into a unique list?

Use a pivot table. Select any cell in your table, then go to Data-Pivot
table and click on Finish. In the diagrm that comes up, drag the Names to
the row area and the data to the data area. Right click on the data field
name and choose average

"Hicoda" wrote:

I have a list of twenty five names. This list contains data from 1 month.
Each name has multipule occurances. I need to create a list of unique names
with the average of each individules data.