Students information

[Jitendra J Dixit]

I got excel sheet wherein the data of Students. I got Sr.No, Roll No, Reg No, Name and Marks as coloumn Head

Below Marks coloumn I got Highest Marks and lowest marks by using max and min function, How do I get other details like Sr.No, Roll No, Reg No, Name of the student who got highest and lowest marks.
Thanks in adv.

 

[shrivallabha]

In cell B7 (Copy to B9) :
=INDEX($B$2:$B$5,MATCH(E7,$E$2:$E$5,0))
In cell C7 (Copy to C9) :
=INDEX($C$2:$C$5;MATCH(E7;$E$2:$E$5;0))
and so on...

 

[Somendra Misra]

Hi,

See this file with another formula solution which involved VLOOKUP.

Regards,

 

[Jitendra J Dixit]

In cell B7 (Copy to B9) :
=INDEX($B$2:$B$5,MATCH(E7,$E$2:$E$5,0))
In cell C7 (Copy to C9) :
=INDEX($C$2:$C$5;MATCH(E7;$E$2:$E$5;0))
and so on...

Thank you Sir

 

[Jitendra J Dixit]

Hi,

See this file with another formula solution which involved VLOOKUP.

Regards,

Hello Somendra Ji,

thank you very much once again.... J J Dixit

 

[Jitendra J Dixit]

Hello Somendra Ji,

thank you very much once again.... J J Dixit

Somendra Ji
Again disturbing you, in the instant example I am asked to show the details of 3 student who secure highest marks, with the "large" function (instead of Max()) I got the answer. Now if there are 3 student on the second position having equal marks, how would I get that, Pl suggest.
Thanks in Advance
J J Dixit

 

[Jitendra J Dixit]

Hi,

See this file with another formula solution which involved VLOOKUP.

Regards,

In cell B7 (Copy to B9) :
=INDEX($B$2:$B$5,MATCH(E7,$E$2:$E$5,0))
In cell C7 (Copy to C9) :
=INDEX($C$2:$C$5;MATCH(E7;$E$2:$E$5;0))
and so on...

Hi Dear Ji
Again disturbing you, in the instant example I am asked to show the details of 3 student who secure highest marks, with the "large" function (instead of Max()) I got the answer. Now if there are 3 student on the second position having equal marks, how would I get that, Pl suggest.
Thanks in Advance
J J Dixit

 

[NARAYANK991]

Hi ,

See the file.

Narayan