Search results

Narayan, I got it how it is working. I used Index/Match to get my Subject toppers list. Thank you. Fareed

Narayan, I am adding something and come back to you. Fareed

Hi Narayan, Addl Info: If he gets <40 in any subject, the credit will be "0" automatically. So now it's more clear I think. I face the difficulty with the format of the database. I have no clue using any right formula to get the info. Fareed

Hey Narayan, Thank you for looking at my query first. If somebody got a "0" credit, just forget about him as he is in the failed list, But one should get a minimum of 40% on an aggregate(total marks/total subjects)to be passed (obviously with all credits >0). And for counting a topper...

Dear Ninjas, Any clue about my query? I am eagerly waiting for somebody to involve in this. Thank you Fareed

Hello all, This is the download link for my above problem. https://rapidshare.com/files/1439311899/Results.xlsx Thanks for every helping hand. Regards Fareed

Hello Everybody, I have problem in analyzing the College exam results. The columns goes like this.. A1.Exam TickettNo, B1.SubjectCode, C1.SubJectName, D1.Theory, E1.Practicals, F1.Credits. The Database will be having 4000+/- rows and 11 subjects and 300/400 students. Please save me by...

Wow..Its working fine.. Thanks alott Narayan.

Hello Chandoo, I am a newbie here , came up with a problem with IF, AND, OR conditions. I have my columns like this: Sno,Empname,Dept,Rating,DOJ,OldSalary,Increment,Bonus,New Salary. To get a bonus of 40,000/-, he should be either from Sales dept OR Marketing dept AND his DOJ should be...