M
murali sachi
Hi,
I have a requirement to display the maximum scored students based on
the marks. i can able to display only one student if more than one
scored the same marks i want to display there name also.
example
sl.no studentname mark
1 john 90
2 paul 95
3 sam 80
4 michel 95
using this formula =INDEX(B:B,MATCH(MAX(C:C),C:C,0)); i can able to
display the value only "paul". i want to display both "paul and
michel".
Please help us on this.
Thanks in Advance..
I have a requirement to display the maximum scored students based on
the marks. i can able to display only one student if more than one
scored the same marks i want to display there name also.
example
sl.no studentname mark
1 john 90
2 paul 95
3 sam 80
4 michel 95
using this formula =INDEX(B:B,MATCH(MAX(C:C),C:C,0)); i can able to
display the value only "paul". i want to display both "paul and
michel".
Please help us on this.
Thanks in Advance..