+ Reply to Thread
Results 1 to 3 of 3

Need advice on Excel course

  1. #1
    Registered User
    Join Date
    07-08-2008
    Location
    UAE
    Posts
    7

    Need advice on Excel course

    please guys help me am taking this course in excel and am about to fail it

    my instructor gave us this bonus assignment to get more marks

    if i didnt get this assignment right am gonna fail the course so please help

    and of course my instructor always gives us these HARD assignments



    ok the assignment is:


    in this work book we have 2 sheets

    sheet 1: you'll find all the semester the student took and in each all the courses


    sheet 2:you'll find all the students ID and all the courses and the grades for the courses


    what he want is:>>>>>>>>>>>


    in sheet 1 when i write the student ID it should show me all the grades for the courses he took in each semester and also the extra ones


    i hope i made it clear for you guys i think i should use (VLOOKUP) but what do i know
    Attached Files Attached Files
    Last edited by VBA Noob; 07-09-2008 at 03:57 AM.

  2. #2
    Registered User
    Join Date
    06-24-2008
    Location
    Cambridge UK
    Posts
    53
    I don't understand. You want people to do your work for you? Or do you want people to help?

    If the latter, at least try to use the VLOOKUP command. It is a little complicated, but the best way to learn is by doing it yourself, not asking someone to do it for you.

    If you get stuck, then perhaps show us what you have done and ask for some guidance.

  3. #3
    Registered User
    Join Date
    07-08-2008
    Location
    UAE
    Posts
    7
    am not asking to do me the work

    the work is only 1 thing to do

    i tryed the VLOOKUP and the IF function and still i didnt get it right


    that's why am asking you guys how can i show the grades when i enter the student ID number


    why everybody keep asking me these Q.....am just asking for help is it that hard to respond?!?!?!?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1