Forum Discussion
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. ...
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))
)
Thank You Sergei!!! I got this resolved.
Cohutta68 , you are welcome