Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Display Of Marksheet Format

  1. #1
    Join Date
    9th May 2007
    Posts
    3

    Display Of Marksheet Format

    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

    follows:

    Roll No.

    Name


    Subject Marks Grade

    A
    B
    C
    D
    E
    F
    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 xxxxxxxxxx@gmail.com

    Thanks in advance

    Ravi.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by ByTheCringe2; May 10th, 2007 at 00:35.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Display Of Marksheet Format Pls Hlp

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    9th May 2007
    Posts
    3

    Re: Display Of Marksheet Format

    Dear Moderator,

    Thank you very much for blanking my email address, I am sorry next time I wont do the mistake.

    Thanks for Cooperation and support.

    With Regards,

    Ravishankar

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,332

    Re: Display Of Marksheet Format

    See the attached for one way to do what you ask.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

  5. #5
    Join Date
    9th May 2007
    Posts
    3

    Re: Display Of Marksheet Format

    Dear Derk,

    Thank you very much for the help, I would try to code the formula and use it in the final worksheet.

    If I have any problem then I will contact you.

    Thanks a lot

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Display Format Axis Menu
    By huntersh in forum EXCEL HELP
    Replies: 1
    Last Post: June 27th, 2007, 21:30
  2. Time display format
    By Disturbedleper in forum EXCEL HELP
    Replies: 3
    Last Post: June 28th, 2006, 16:05
  3. format to display a '-' if the cell value is 0
    By Joozh in forum EXCEL HELP
    Replies: 4
    Last Post: January 20th, 2006, 20:27
  4. Display Time Format in MsgBox
    By J88L in forum EXCEL HELP
    Replies: 2
    Last Post: December 30th, 2005, 00:37
  5. Textbox display format
    By PM Guy in forum EXCEL HELP
    Replies: 2
    Last Post: March 22nd, 2005, 05:58

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno