I have this forumula below that quits working if it goes beyond approximately row 4500. If I go out to Row 6700 it returns N/A# for the result.
= IFERROR(INDEX($B$2:$B$4489,SMALL(IF($F$2:$F$4489=A$4519,ROW($B$2:$B$4489)-1),ROW(B1))),"")
Is there a limit to the number of rows or number of "hits" in the IF statement? There is alot of information in Column B that does not match the value in A$4519. Currently a count of 1,102.
At one point, I used named ranges and that did not work well either.
I am looking within a series of 80 or so similarly constructed tables (Row 2 to Row 6700 or so), one above each other, to extract the results of a match between cell A$4519 and what is is Column B, then select the information in Column A of that row and them populate a table below. Then I need to find the next entry until I have exhausted all of the range for that match.
I adapted the formula in Cell H5 of the attached spreadsheet that I borrowed from another thread.
Other ideas about how to get what I am after would be most helpful. Thanks.
Bookmarks