Another query for which I would really appreciate any help.
I am trying to provide departments a breakdown on their subject and one of the sections is a list of students who are under performing and have behaviour issues. I have found a formula to do this but I am trying to automate the process as much as possible so have set it up for one department but if I change the subject to say Maths it automatically populates the spreadsheet by matching the column headers. The formula I am using to extract the list is:
=IF(COUNTIFS('Raw Data excel'!$AH:$AH,"<0",'Raw Data excel'!$GO:$GO,">=3",'Raw Data excel'!$IG:$IG,">=3")<ROWS($A$72:A72),"",INDEX('Raw Data excel'!A:A,SMALL(IF(('Raw Data excel'!$AH$2:$AH$269<0)+('Raw Data excel'!$GO$2:$GO$269>=3)+('Raw Data excel'!$IG$2:$IG$269>=3)=3,ROW('Raw Data excel'!$A$2:$A$269)),ROW('Raw Data excel'!A1))))
Any ideas on how this can be changed to so that instead of extracting data from columns it extracts data if the column header matches?
Thanks
I am trying to provide departments a breakdown on their subject and one of the sections is a list of students who are under performing and have behaviour issues. I have found a formula to do this but I am trying to automate the process as much as possible so have set it up for one department but if I change the subject to say Maths it automatically populates the spreadsheet by matching the column headers. The formula I am using to extract the list is:
=IF(COUNTIFS('Raw Data excel'!$AH:$AH,"<0",'Raw Data excel'!$GO:$GO,">=3",'Raw Data excel'!$IG:$IG,">=3")<ROWS($A$72:A72),"",INDEX('Raw Data excel'!A:A,SMALL(IF(('Raw Data excel'!$AH$2:$AH$269<0)+('Raw Data excel'!$GO$2:$GO$269>=3)+('Raw Data excel'!$IG$2:$IG$269>=3)=3,ROW('Raw Data excel'!$A$2:$A$269)),ROW('Raw Data excel'!A1))))
Any ideas on how this can be changed to so that instead of extracting data from columns it extracts data if the column header matches?
Thanks
