How to create a array formula to retrieve data?

Hi Ford,
No, I don’t want to add helping column because there is no place for it. I have another data there which I don’t want to move to avoide any programming error.

Hi Siva,
Good! It's working absolutely fine as per my requirement but one little amendment is require to make it fullproof.

See subject 'Hindi general and Hindi Special' If I enter 'Hindi' then it gives output of 'Marathi'.

Sorry for not mentioning it before that the 'Hindi general' and 'Hindi special' are count as one subject while ranking. See ranking formula for reference.

Amendment require:

If I enter a subject 'Hindi' instead of 'Hindi general' and 'Hindi special' then it should be count as one subject group.

Output require for Hindi:

1 Hindi general B2 67/100 Std. 5 B 0.67 1
2 Hindi general D2 61/100 Std. 5 D 0.61 2
3 Hindi special C2 57/100 Std. 5 C 0.57 3
4 Hindi general A2 55/100 Std. 5 A 0.55 4
5 Hindi special E2 33/100 Std. 5 E 0.33 5


Sorry for trouble.

Thank you.