Need help on vba code/excel formula to use!

ynyend1

New Member
Joined
Jul 12, 2013
Messages
12
Office Version
  1. 2019
Platform
  1. Windows
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!

SAMPLE FILE FOR FORMULA HELP.xlsx
AA
339
Sheet1
Cell Formulas
RangeFormula
AA3AA3=IFERROR(AVERAGE(C3,O3),"")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A3:AK4Expression=$A3=""textNO
Cells with Data Validation
CellAllowCriteria
B3:B4ListME,KE
C3:AK4Whole numberbetween 0 and 100
 

ynyend1

New Member
Joined
Jul 12, 2013
Messages
12
Office Version
  1. 2019
Platform
  1. Windows
Not in This workbook. Go to Insert Module and paste code only one time.
And Delete all codes with same name at workbook.
Helloooo..
I have now realised where the problem is..
It's because my data are Formatted as Table.... If I convert them to Range it works perfectly...
Is there a way to make a code that is compatible with Table format! It's because my template has some linked data to Power Query from Excel Tables... If there is no way then I will know what to do...
Thank you for your tireless efforts
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,144,340
Messages
5,723,804
Members
422,518
Latest member
quack_quack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top