Dear All
This is probably very simple for some of you, but I seem to have drawn a blank.
I have the following table
Name Student Year Group Task 1 Task 2 etc
Student 1 Year 7 45% 77%
Student 2 Year 8 25% 34%
Student 3 Year 7 34% 90%
I want a formula to pull out all year 7s and show the highest percentageachieved in Task 1. (In this case 45% but my list is huge). I will then do the same formula but for Year 8s etc.
Please help. Thank you
In a cell put this formula =INDEX(MAX(Table1[Task1]);MATCH("Year 7";Table1[Year Group];0)).
I hope this is what you want.
Regards,
Elio Fernandes
Last edited by efernandes67; 06-23-2012 at 04:48 PM.
How about using a Pivot Table? See attached.
Or, you can try this array formula
{=MAX(IF($B$2:$B$4=$F2,$C$2:$C$4))}
Excel Help_840523.xlsx
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks