Forum Discussion
Linking table to part of another table that sorts adjacent data
I'm creating a marking sheme for teachers and want to link tables across multiple sheets. 1. The file will have multiple sheets for each test. eg: Sheet 1 = Test 1 Sheet 2 = Test 2 etc There ...
Hi JKPieterse
Here is a snapshot of what the sheet looks like currently in the snapshot shows an example of a formula used:
- Columns D, E, F, J, K, O, P, Q and R are entered manually. These are the total marks for each section in the tests of the respective subjects
- Totals (i.e. columns G, L and S) are calculated using the SUM function (columns G, L and S)
- Columns H, M and T use a version of the function seen in the snapshot i.e. =IF([@[MathTotal]]="","",([@[MathTotal]]/$G$4)*100)
- Columns I, N and U use a version of this function: =IF([@[M%]]="","",([@[M%]]/$H$4)*$I$4)
- And the overall grade is calculated using the data in columns I, N and U i.e. =IF(OR([@[MW%]]="",[@[ELAW%]]="",[@[CWW%]]=""),"",(([@[MW%]]+[@[ELAW%]]+[@[CWW%]])/2)*100)
- If and OR functions are used so the cell remains blank if there is no data to pull
- Jan_Karel_Pieterse if this would be the best way to go about it then yes, help or suggestions will definitely be needed
mayabrx It would help if you could upload an anonymized version of your current workbook.
JKPieterse I'm not 100% sure how to do that. I initially tried uploading the doc and wasn't successful. Would I upload to excel online and link it here?
