standaman7
New Member
- Joined
- Apr 16, 2013
- Messages
- 3
afternoon,
i have the formula below to pull from an array. the problem is that the data im using for the array contains 20000+ rows. The function works fine for about the first 10 lines and then i get random data that is pulled from my data source. any help?
{=IF(ROWS($C2:$C2)>$A2,"",INDEX('XX File'!$A$2:$A$29428,SMALL(IF(('XX File'!$F$2:$F$29428<='Input'!$A2)*('XX File'!$G$2:$G$29428>='Input'!$A2)*('XX File'!$A$2:$A$29428='Input'!$B2),ROW('XX File'!$A2:$A29428)-ROW('XX File'!$A$2)+1),ROWS(C2:C2))))}
i have the formula below to pull from an array. the problem is that the data im using for the array contains 20000+ rows. The function works fine for about the first 10 lines and then i get random data that is pulled from my data source. any help?
{=IF(ROWS($C2:$C2)>$A2,"",INDEX('XX File'!$A$2:$A$29428,SMALL(IF(('XX File'!$F$2:$F$29428<='Input'!$A2)*('XX File'!$G$2:$G$29428>='Input'!$A2)*('XX File'!$A$2:$A$29428='Input'!$B2),ROW('XX File'!$A2:$A29428)-ROW('XX File'!$A$2)+1),ROWS(C2:C2))))}