Re: $$Excel-Macros$$ Min With Index

2015-09-15 Thread De Premor
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

$$Excel-Macros$$ Min With Index

2015-09-15 Thread Chandra Shekar
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