Listing a text based on Connditions - Microsoft Excel Hi, I hope someone could a

Question

Listing a text based on Connditions - Microsoft Excel

Hi,

I hope someone could aanswer my query here. I want Excel to list down the names of passers as well as failed students in an exam. I have attached the screen shot for the actual desired result.

Thanks a lot!!!

Listing a text based on Connditions - Microsoft Excel Hi, I hope someone could aanswer my query here. I want Excel to list down the names of passers as well as failed students in an exam. I have attached the screen shot for the actual desired result. Thanks a lot!!!

Explanation / Answer

Hi,,,,

In cell B19, enter this array formuula (Ctrl+Shift+Enter) and copy down

=IFERROR(INDEX($B$4:$B$13,SMALL(IF($C$4:$C$13>=1,ROW($B$4:$B$13)-ROW($B$3)),ROW(1:1)),1),"")

In cell D19, enter this array formula (Ctrl+Shift+Enter) and copy down

=IFERROR(INDEX($B$4:$B$13,SMALL(IF($C$4:$C$13<1,ROW($B$4:$B$13)-ROW($B$3)),ROW(1:1)),1),"")

Hope this helpss...

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.