Forum Discussion

Cohutta68's avatar
Cohutta68
Copper Contributor
Jan 13, 2021

Help limiting length results of results from Filter Formula without #REF!

Hey, I am building a new Excel (365) app to track our operations.   On the job specific pages, I am trying to return (via Filter Formula) just the first 'up to 10 rows" of data from another range. ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 13, 2021

Cohutta68 

If FILTER() returns less than 10 rows, INDEX returns REF since you try to reference not existing rows. Variant could be

=LET(
 filt, FILTER('WO Labor Index'!$A$3:$A$10000,
              'WO Labor Index'!$B$3:$B$10000=A2),
 n, ROWS(filt), INDEX(filt,SEQUENCE(n))
)
  • Cohutta68's avatar
    Cohutta68
    Copper Contributor
    Jan 13, 2021
    Thank You Sergei!!! I got this resolved.

Resources