Hello everyone
I have data in range("A8:N200") with headers in row 8 ..
I would filter data according to field N ...
To get filtered value in cell B5 I used this array formula
=INDEX(N9:N200,MATCH(1,(SUBTOTAL(3,OFFSET(N9:N200,ROW(N9:N200)-MIN(ROW(N9:N200)),0,1)))*(N9:N200<>""),0))
I need to convert it to UDF function so as to add a point
The point I need to add is that to return empty if filtered mode=false ..
Hope it is clear
Thanks advanced for help