I have this formula that i want to apply to visible cells only. It currently works fine but I know want to filter a specific parameter.

=IF(ISBLANK(F6),0,VLOOKUP(RANK(H6,$H$6:$H$37,1),$BO$8:$BP$37,2,1))

I am trying to rank only the visible cells in column H