hey i have data for a set of people for 3 months ,
data contains id , name and score for each month
during the term of this data there have been new people added to the list and people taken out
i only need excel to sort the data in accending order of these people ids and compute the avg of their scores
ive added the sample excel file to my geocities acc so u can download it and tell me what function to use
http://geocities.com/daylesoares/Book1.xls
data contains id , name and score for each month
during the term of this data there have been new people added to the list and people taken out
i only need excel to sort the data in accending order of these people ids and compute the avg of their scores
ive added the sample excel file to my geocities acc so u can download it and tell me what function to use
http://geocities.com/daylesoares/Book1.xls