Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 25

Thread: Help on what type of formula should be use?

  1. #1
    New Member
    Join Date
    Mar 2014
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help on what type of formula should be use?

    Hi Everyone, I been cracking my head out but I think Excel should be able to resolve just maybe I am not knowledgeable enough...

    Am using Excel 2010, I need to provide a formula that can generate the course the student is exempted from and what modules student needs to take in order to complete Course 4

    E.G) If Student completed Module ABC, the result should reflect Course 1, 2, 3 & 5.
    I would also need a formula that is able to show Course 4 just require Student to complete Module D

    I was thinking of using Vlookup with CONCATENATE function.. but that doesn't seem to make it..
    Is it possible to generate a formula for this? Appreciate the help and replies!!

    Course 1 Module A Module C
    Course 2 Module B Module D
    Course 3 Module A Module B Module C
    Course 4 Module A Module B Module C Module D
    Course 5 Module A Module B Module C

  2. #2
    Board Regular
    Join Date
    Feb 2013
    Location
    USA
    Posts
    1,161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    I can't make sense of your Data and your results, If a student took ABC shouldn't Course 2 be left off the list?
    -Red


    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

  3. #3
    New Member
    Join Date
    Mar 2014
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Quote Originally Posted by Redwolfx View Post
    I can't make sense of your Data and your results, If a student took ABC shouldn't Course 2 be left off the list?
    Oops.. yes you are right.. I made a mistake in that.

  4. #4
    Board Regular
    Join Date
    Feb 2013
    Location
    USA
    Posts
    1,161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Are the modules for the courses Static? Can I hard code Course 1 will always be Modules A and C?
    -Red


    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

  5. #5
    New Member
    Join Date
    Mar 2014
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Yes, they are static. Modules will always be the same for Course 1

  6. #6
    Board Regular
    Join Date
    Feb 2013
    Location
    USA
    Posts
    1,161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    And where does the information from the Student come from?
    -Red


    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

  7. #7
    New Member
    Join Date
    Mar 2014
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Should be manually inputted on another sheet.

  8. #8
    Board Regular
    Join Date
    Feb 2013
    Location
    USA
    Posts
    1,161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    And is that sheet in a similar Setup?


    Student 1 Module A Module B Module C
    Student 2 Module A Module C Module D
    Student 3 Module B Module D
    -Red


    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

  9. #9
    New Member
    Join Date
    Mar 2014
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Currently no fixed setup. As I wasn't quite sure how to come up with the formula
    In the previous design, the setup was created like below:
    Module A Module B Module C Module D
    Student 1
    Student 2
    Student 3

  10. #10
    Board Regular
    Join Date
    Feb 2013
    Location
    USA
    Posts
    1,161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on what type of formula should be use?

    Are you looking for the information to appear in one Cell? Or could you setup mor e of a form to convey the information? Either one is possible, it will just be a lot easier to set up a form
    -Red


    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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