Hi,
Here is my filter function.
=FILTER('gil2'!$A$2:$D$37,ISNUMBER(MATCH('gil2'!$C$2:$C$37,'gil2'!$M$8:$O$8,0)))
It works fine, but I would like it to be dynamic so the last row will be a result of "counta" or any other counting function instead a fix number (in the function here it is 37).
TIA
Nati
Here is my filter function.
=FILTER('gil2'!$A$2:$D$37,ISNUMBER(MATCH('gil2'!$C$2:$C$37,'gil2'!$M$8:$O$8,0)))
It works fine, but I would like it to be dynamic so the last row will be a result of "counta" or any other counting function instead a fix number (in the function here it is 37).
TIA
Nati