Welcome to the forum, ravishankar, but why the double-spacing? We don't email answers, and I have blanked out your email address to stop you getting spam.
Also read the rules about titles!
Need help regarding formulas...
Hi all friends,
I am having a problem and i need some help from you. I am having a data of about 500 students and
each student has 6 subjects A,B,C,D,E,and F. Now the thing is that it is not necessary that a
student must give all papers to pass in exam, it depends on what options the student has
selected. We have made a table in a form given below
RollNO. Name. A Mark Grade B Mark Grade and so on till F Mark Grade.
In the next sheet we have used the function V lookup and printed a format of marksheet as
Subject Marks Grade
ALL USING VLOOKUP
Vlookup Vlookup Vlookup
so when in the next sheet we enter the roll no. the name field and the subject marks and grade
field all Come automatically, now let me tell u the exact problem, if a student has not given C
and E subject, because of Vlook up function ans using if function the fields in place of C and E
subject are left blank and the marksheet is not looking good. Now what i want is that if a
student has not given C paper the subject, mark and grade of D paper should come in place of C
paper place,, so that there would be no gap.. if a student has only attempted paper F instead of
a big gap and then the mark of F the mark of F should come in place of A. I hope u understood
what i meant, for further experimentation I am also ready to mail u a format of marksheet that I
have made, so that u can understand it better. please try to suggest me some solution to the
problem.. ....pls mail answers to email@example.com
Thanks in advance
Last edited by ByTheCringe2; May 10th, 2007 at 00:35.
See the attached for one way to do what you ask.
Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.
There are currently 1 users browsing this thread. (0 members and 1 guests)