Dec 13 2019 10:17 PM
I have this formula that I use to return about 50 values. Of the 50, 3 is incorrect somehow for those 3 it select the next row which doesnt fall in the criteria but it does it anyway. If I search and get 8 values, 3 is incorrect. I am at a loss, why would it do that:
Example: This is in Row22 and it is correct:
=IFERROR(INDEX(REPAIR_TB,SMALL(IF(REPAIR_TB[RMR]=$B$10,ROW(REPAIR_TB[RMR])),ROWS(A$22:A22)),5),"")
Same formula is in Row 73 and it return a incorrect info
=IFERROR(INDEX(REPAIR_TB,SMALL(IF(REPAIR_TB[RMR]=$B$10,ROW(REPAIR_TB[RMR])),ROWS(A$22:A73)),5),"")
Please help
Dec 13 2019 11:30 PM
Can you please upload a workbook that demonstrates the formula, and indicate why some of the results are incorrect? And what result would you want to see for these errors.