Array formula problem

[steveg666]

is it possible in an array formula when you have found the information required to hide the balance of the array formula but not loose the function of the remainder rows just not display the #num! . i.e if the array is set for 10 rows and only 5 results are shown how to hide the other 5 rows with no results. please see attached work book. very new to this and any help would be appreciated.

[Fotis1991]

Use IFERROR in front of your formulas.

Example

=IFERROR(INDEX(Φύλλο1!A$3:A$1000,SMALL(IF(Φύλλο1!$B$3:$B$1000>0,ROW(Φύλλο1!A$3:A$1000)-2),ROW(Φύλλο1!A1))),"")

[steveg666]

hello fotis1991 thank you for replying but im having problems when i enter the iferror to the array its comes up say either to many or not enough arguments and i dont understand enough to fix it any help much appreciated. if you could do one on the example even better

[Fotis1991]

Here you are.

[steveg666]

fotis1991 you are a super star well done perfect result still not sure what i did wrong will have to study it more

Thank You

[Fotis1991]

.........................