Forum Discussion
How do I organize students best results?
Hi to everyone. For work, I am given a wide amount of datas to organize: these datas contain, for each student of an accounting course, in columns, the name of the test they took (it's 2 differen...
Hi Alexia,
I would recommend using Pivot Table feature in Excel.
1) Select the data
2) Select Pivot Table from Insert menu
3) Drag Student details (ID, First Name, Last Name,..) to Rows
4) Drag Course details (ID, Name,..) to Columns
5) Drag score/marks to Values
6) Change 'Sum of Score' to 'Max of Score' from the Value Field Settings
Resulting table will give you the best score of every student for each course. I have attached a sample for you to check out.
Good luck!
Cheers,
Kasi