need help with this sorting data

dayle

New Member
Joined
Oct 5, 2006
Messages
1
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
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
ABCDEFGHI
1idnamejanscore
2a001xjan2AVERAGEscore
3a002yjan2idnameTotal
4a003zjan1a001x2.333333333
5a005ajan4a002y2
6a009bjan3a003z2
7a001xfeb4a004t3
8a003zfeb4a005a4
9a009bfeb1a009b2
10a012pfeb3a011n4
11a019qfeb1a012m3
12a012mmar3p3
13a011nmar4a019q1
14a001xmar1GrandTotal2.466666667
15a003zmar1
16a004tmar3
17after
18avg
19idnamescore
20a001x2.33
21a003z2.00
22
23
24
25
26
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,114,053
Messages
5,545,740
Members
410,703
Latest member
yaronjoseph
Top