+ Reply to Thread
Results 1 to 3 of 3

Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Dodoma, Tanzania
    MS-Off Ver
    MS 2019
    Posts
    6

    Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE

    Hello all
    Greetings!
    I have attached a workbook here containing sample data and clear explanation of what I need.
    This is what I want to achieve:

    I need an Excel formula/VBA Code that will do the following:
    1: Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE which will change automatically as average marks changes for each subject as per the criteria given in column AO and AP.. Refer to the combined results column in the attached workbook for the output I want; then:
    2: If the student does not take any of the above subjects then it should not concatenate that particular subject with its marks, it should leave it blank and proceed to the next subject; refer to the second student in the attached sheet (check the combined result for the second students, that's the output I want).

    I will highly appreciate for your help!
    Attached Files Attached Files
    Last edited by alansidman; 05-06-2021 at 04:43 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,668

    Re: Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    Use concise, accurate thread titles.
    Your post title should describe your problem, not your anticipated solution.
    Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    Since you are new to the forum, I have changed the title for you today.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,598

    Re: Concatenate the SUBJECT NAME in the average results with the DYANAMIC LETTER GRADE

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you seem to not have posted recently I will do it for you this once https://chandoo.org/forum/threads/he...yustino.46223/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code for excel if formula
    By devawad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 05:48 AM
  2. [SOLVED] vba code for excel formula
    By devawad in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-03-2014, 12:55 PM
  3. Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  4. how to right excel formula with vba code.
    By Sushil.thakur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2013, 04:59 AM
  5. Excel Formula into DBA code
    By moroformat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2013, 04:54 AM
  6. [SOLVED] Change my code into Excel formula code
    By DGARRETT1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-04-2013, 07:51 PM
  7. [SOLVED] Excel formula to VBA code
    By purin0c0 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2012, 03:18 PM
  8. lookup data and copy related cell
    By Ronsco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-05-2012, 02:47 AM

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