Ineed formula

[MAHMOUD-LEE]

[TABLE="width: 630"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]م[/TD]
[TD]الاسم[/TD]
[TD]رقم الجلوس[/TD]
[TD]تاريخ الميلاد[/TD]
[TD]عربي[/TD]
[TD]علوم [/TD]
[TD]رياضيات[/TD]
[TD]انجليزي[/TD]
[TD]دراسات[/TD]
[TD]المجموع[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ايمن[/TD]
[TD]10[/TD]
[TD]15/04/2000[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]24[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]107[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]سلامة[/TD]
[TD]11[/TD]
[TD]21/03/2000[/TD]
[TD]23[/TD]
[TD]29[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]25[/TD]
[TD]129[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]سيد[/TD]
[TD]12[/TD]
[TD]25/06/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]137[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]محمد[/TD]
[TD]13[/TD]
[TD]13/07/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]139[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]محمود[/TD]
[TD]14[/TD]
[TD]01/04/2000[/TD]
[TD]18[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]87[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]وائل[/TD]
[TD]15[/TD]
[TD]18/08/2000[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]26[/TD]
[TD]118[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]وليد[/TD]
[TD]16[/TD]
[TD]16/07/2000[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]15[/TD]
[TD]18[/TD]
[TD]107[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]اسماء[/TD]
[TD]17[/TD]
[TD]29/01/2000[/TD]
[TD]30[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]132[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]سامية[/TD]
[TD]18[/TD]
[TD]15/01/2000[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]124[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]غادة[/TD]
[TD]19[/TD]
[TD]14/07/2000[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]20[/TD]
[TD]117[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]منى[/TD]
[TD]20[/TD]
[TD]25/06/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]137[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]هدير[/TD]
[TD]21[/TD]
[TD]01/04/2000[/TD]
[TD]18[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]87[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 10"]I want to arrange the equation of students by the total and if equal to the total be younger and if equals Age be in alphabetical order.
NB: I want to appear respectively in a column arrangement while maintaining the survival of student's name in the location for the No. sit in alphabetical order example if Ayman is the tenth appears in front of him in a column arrangement (X) with the survival of Ayman in the same ranking alphabetical order No. sitting,,, ,,,,,,,,,,,,,,,
May Allah reward you[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

do not list more than once as nobody will help you

 

[MAHMOUD-LEE]

My teacher can delete links and deal with a single link, because it happened because of the weakness of the net I have, so I'm sorry about that

 

[MAHMOUD-LEE]

[TABLE="width: 881"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]No. Sitting[/TD]
[TD]Date of Birth[/TD]
[TD]Arabic[/TD]
[TD]Science[/TD]
[TD]Mathematics[/TD]
[TD]English[/TD]
[TD]History[/TD]
[TD]Total[/TD]
[TD]rank[/TD]
[/TR]
[TR]
[TD]Ayman[/TD]
[TD]10[/TD]
[TD]15/04/2000[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]24[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]107[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]salama[/TD]
[TD]11[/TD]
[TD]21/03/2000[/TD]
[TD]23[/TD]
[TD]29[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]25[/TD]
[TD]129[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]saied[/TD]
[TD]12[/TD]
[TD]25/06/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]137[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mohamed[/TD]
[TD]13[/TD]
[TD]13/07/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]139[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mahmoud[/TD]
[TD]14[/TD]
[TD]01/04/2000[/TD]
[TD]18[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]87[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wael[/TD]
[TD]15[/TD]
[TD]18/08/2000[/TD]
[TD]19[/TD]
[TD]21[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]26[/TD]
[TD]118[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Walid[/TD]
[TD]16[/TD]
[TD]16/07/2000[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]15[/TD]
[TD]18[/TD]
[TD]107[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]asmaa[/TD]
[TD]17[/TD]
[TD]29/01/2000[/TD]
[TD]30[/TD]
[TD]23[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]28[/TD]
[TD]132[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Samia[/TD]
[TD]18[/TD]
[TD]15/01/2000[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]124[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ghada[/TD]
[TD]19[/TD]
[TD]14/07/2000[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]20[/TD]
[TD]117[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mona[/TD]
[TD]20[/TD]
[TD]25/06/2000[/TD]
[TD]30[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]24[/TD]
[TD]28[/TD]
[TD]137[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]hadeer[/TD]
[TD]21[/TD]
[TD]01/04/2000[/TD]
[TD]18[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]87[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

highlight any cell in your table then click on data, sort, choose total descending, then date of birth descending, then name ascending.

 

[MAHMOUD-LEE]

But I need this method by FORMULA

 

[MAHMOUD-LEE]

up

 

[oldbrewer]

I have solved it using formulas but had to use 10 helper columns - this is not the way to do this, sorry I cannot help further.

 

[MAHMOUD-LEE]

I want Filter relies on only 3 columns are the (total), (date) and (alphabet)

 

[MAHMOUD-LEE]

UP