create a list of student in different grades in separate sheets

[KIBAAKO]

{=INDEX('SENIOR BOYS'!A$5:A$684,SMALL(IF('SENIOR BOYS'!F$5:F$684=G5,ROW('SENIOR BOYS'!$F$5:$F$684)-ROW('SENIOR BOYS'!F$5)+1),COUNTIF(G$5:G5,G5)))}
Hi. The above formula I supposed to create a list of student in Grade 7 and those of students in Grade 8 in separate sheets in order of performance (i.e score)(RAW MARKS ARE IN ‘SENIOR BOYS’ SHEET). My problem is that the scores are correct, but there is a mix-up in Grades, Names, Dorm and even Team Code.
I would be grateful for your assistance. Thanks
Attached is my workbook, named HIGHLANDS ACADEMY


Thanks in advance.

[tim201110]

i'd do it with helper column
BTW autofilter can do it

[kvsrinivasamurthy]

Pl see file.
No helper columns
ARRAY formulas
IN B5 of Sheet for Grade 7 then drag across

Please Login or Register  to view this content.

IN B5 of Sheet for Grade 8 then drag across

Please Login or Register  to view this content.

[KIBAAKO]

I am so grateful for your effort above, however, there are still some problems, thus:
(1) there is duplication of names,
(2) there are missing names in the respective grades.
NB: TOTAL NUMBER OF STUDENTS IN GRADE 7 = 271 while GRADE 8 = 409

Looking forward for your assistance

[kvsrinivasamurthy]

Pl post a sample file showing the expected results with explanation.

[KIBAAKO]

[SIZE=]Thanks,
EXPLANATION is that I will be entering raw marks in SENIOR BOYS SHEET, whereas GRADE 7 and GRADE 8 SHEETS are to be automatically generated using ARRAY FORMULAS .
I have attached the same file, but i have sorted GRADE 7 and GRADE 8 sheets manually, to show how the results are supposed to be. Thank you[/SIZE]

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Also, there is no need to use large (or any fancy) font like that

[kvsrinivasamurthy]

Pl act for post#7

[Czeslaw]

I propose a variant with formulas for
column G

Please Login or Register  to view this content.

and columns B-F

Please Login or Register  to view this content.

[KIBAAKO]

please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a pm and i will remove this request. (also, include a link to your thread - copy from the address bar)

many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

to change a title on your post, click edit post then go advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: This change is not optional )

also, there is no need to use large (or any fancy) font like that

admin, please am giving you an express permission to assist in post #7. I've tried my level best, but all in vain. Thanks in advance

[FDibbins]

I have added a title for you, thanks for trying

(also I have restored the post I hid)