Hi Chandra,
You need to put Match Type on that MATCH formula
=INDEX(A2:B6;MATCH(MIN(B2:B6);B2:B6*;0*);1)
Rgds,
[dp]
On 15/09/2015 14:24, Chandra Shekar wrote:
Hello,
Am trying to find out student name who scored min marks using index &
min function but its giving error. Could you please find
Hello,
Am trying to find out student name who scored min marks using index & min
function but its giving error. Could you please find attached workbook and
let me know where its wrong.
Thanks,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N