I have this working on other sheets, but on this one, it pulls only every 4th result. I am at a complete loss....
I have attached an example.![]()
=IFERROR(INDEX(Overrides!A2:AA81,SMALL(IF((Overrides!L2:L81=$I$2)*(Overrides!M2:M81>0.01),ROW((Overrides!A2:A81))-1),ROW(A1)),27),"")
Thank you for any and all help!
Attachment 296905
Bookmarks