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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
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
 

Forum statistics

Threads
1,140,916
Messages
5,703,161
Members
421,278
Latest member
16cwilliams

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top