Mar 100 64 =INDEX($A$1:$A$6,MATCH(MIN($C$1:$C$6),$C$1:$C$6,0))&" - "&MIN($C$1:$C$6)&"/"&INDEX($B$1:$B$6,MATCH(MIN($C$:$C$6),$C$1:$C$6,0))
Hin 100 62
Eng 100 48
Math 150 52
Sci 100 49
Soci 100 55
Above formula give minimum but its wrong becouse Math Subject Out of Marks is 150 then 52 obtained marks is minimum
How to Calculate such type of minimum.
Bookmarks