Forum Discussion

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

JMB17

Bronze Contributor

Jan 13, 2021

I don't have the newest functions to test this, but could you replace 10 with MIN(10, countif()) where countif returns the number of items matching your condition?

Or, could you wrap the index function with iferror and return either blank or zero?

Cohutta68
Copper Contributor
Jan 13, 2021
Thank You!!! I got this resolved.