Here is the formula, I figured it out myself:
=IF(ROWS($A$2:$A2)>COUNTIF('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000,"Riley Orchards"),"",INDEX('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$U$6:$U$1000,SMALL(IF('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000="Riley Orchards",ROW('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6:$F$1000)-ROW('[2012 Tart Cherry Check Grades.xlsx]Master SC'!$F$6)+1),ROWS($A$2:$A2))))
Bookmarks