Forum Discussion
Solved
INDEX Array with OR Function
Hi, I'm looking for some help adding an 'OR' function to my index array. My first formula looks for attendance below 96%, and the second formula looks for number of times late over 5. =IFERR...
Does this work?
=IFERROR(INDEX($R$2:$R$2000,SMALL(IF(($BE$2:$BE$2000<=96%)+($AD$2:$AD$2000>=5),ROW($R$2:$R$2000)),ROW(1:1))-1,1),"")
Does this work?
=IFERROR(INDEX($R$2:$R$2000,SMALL(IF(($BE$2:$BE$2000<=96%)+($AD$2:$AD$2000>=5),ROW($R$2:$R$2000)),ROW(1:1))-1,1),"")
- That's worked perfectly - thank you so much! 🙂
