Jan 11 2019 05:53 PM
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 to create this list. i tried a lot for the past 1 week i cant find a solution. can anyone guide me. i attached my file with this
Jan 11 2019 06:46 PM
You might try working with Pivot Tables.
Jan 12 2019 06:13 AM
Hi! I tried your xlsx File, thanks.
Although i did a pivot table for your out of your xlsx file... Hope that works. There are TONS of tutorials in youtube or on bookboon.com (eBooks) to learn Excel advanced knowledge. Greets, Eva.
Greets, Eva.
Jan 12 2019 09:14 AM
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
Jan 12 2019 10:33 AM
SolutionHi,
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
Jan 13 2019 09:40 AM
Jan 12 2019 10:33 AM
SolutionHi,
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