View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aazharr aazharr is offline
external usenet poster
 
Posts: 1
Default first ten and last ten averages

in one column i have names and in other column i have values. each same name
can have lot of values
so in column A all the names are written , (one name can have more than one
values). and in colum B i have all the values . I want a fuction which gives
me
1. average of first ten , and last ten values of one name .(in two seprate
cells)
2.average of all the values of one name (in one seperate cell).