need help with this sorting data

[dayle]

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

 

[eliW]

hi Dayle and welcome to the board.

Many ways to solve this. but let me suggest the better way (in my opinion) to do this.

Set up your data as shown in the example. you can add and delete records as you need.

Then create a simple Pivot table having id and name in ROW field and Average score in DATA field, and thats done.

HTH

Eli

עותק של Book1.xls
	A	B	C	D	E	F	G	H	I
1	id	name	jan	score
2	a001	x	jan	2		AVERAGEscore
3	a002	y	jan	2		id	name	Total
4	a003	z	jan	1		a001	x	2.333333333
5	a005	a	jan	4		a002	y	2
6	a009	b	jan	3		a003	z	2
7	a001	x	feb	4		a004	t	3
8	a003	z	feb	4		a005	a	4
9	a009	b	feb	1		a009	b	2
10	a012	p	feb	3		a011	n	4
11	a019	q	feb	1		a012	m	3
12	a012	m	mar	3			p	3
13	a011	n	mar	4		a019	q	1
14	a001	x	mar	1		GrandTotal		2.466666667
15	a003	z	mar	1
16	a004	t	mar	3
17							after
18							avg
19						id	name	score
20						a001	x	2.33
21						a003	z	2.00
22
23
24
25
26
Sheet1