Averaging

[CanadianDon]

I have unique identifiers in column A... I then have multiple entries on a different tab... what I need is to find out how to average these entries for each unique identifier in column A on the other sheet...... please help

 

[VoG]

Maybe like this (shown on one sheet for clarity)

Excel Workbook
	A	B	C	D
1	E	10	A	6.6
2	E	3
3	B	7
4	A	1
5	B	7
6	A	9
7	B	8
8	E	6
9	F	3
10	B	7
11	A	10
12	B	4
13	B	10
14	B	8
15	B	1
16	A	6
17	A	7
18	C	9
19	C	3
20	D	9
Sheet1