Excel : Get Value Of Last Visible Cell

i am using this formula in cell B1 to get last value of visible cell

=LOOKUP(2;1/((SUBTOTAL(3;OFFSET(A2:A10;ROW(A2:A10)-MIN(ROW(A2:A10));0;1)))*(1-ISBLANK(A2:A10)));A2:A10)

this formula work good when cell from A1 to A10 not contains formula the problem is this formula not working when the cell have formula like if statement example : in cell a10 i put this formula =IF(F1=1;1;"") the cell a10 show blank because the condition not true - and when i filter data the cell B1 show blank