Forum Discussion
Need assistance with an excel formula
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
Hi Eva thanks for your guidance, i too tried by seeing lot of youtube videos but i think i have not explained my problem correctly. now i created a table in the file attached below which titled "Single subject failures" with all subject names. i need to display the name of the students who got <35 marks only in that subject (for example the second column shows english. it should contain the name of the students who got <35 marks in english subject only and got >35 marks in all subjects). i dont know how to do it. can you guide me
Karthic
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
- Thank you Sergei Baklan. thanks for your guidance you made it simple i was troubling a lot for more than a week using various commands