Forum Discussion
Solved
Need assistance with an excel formula
i am a school teacher working with marks of the student. i need the list of students who got less than 35 marks in one subject (with subject names), two subjects, three subjects etc. i dont know how ...
Hi,
That could be
=IFERROR(INDEX($C$2:$C$37,AGGREGATE(15,6,1/($D$2:$D$37<35)/($E$2:$E$37>=35)/($F$2:$F$37>=35)/($G$2:$G$37>=35)/($H$2:$H$37>=35)/($I$2:$I$37>=35)*ROW($A$2:$A$37)-1,ROW()-ROW($A$52))),"")
for first subject, and similar for others, please see attached. That's a bit straightforward, but with merged cells it's hard to add more flexibility
You might try working with Pivot Tables.