Apply formula only to visible cells

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

Since you're using Excel 2010 - have a look at the AGGREGATE() function: http://office.microsoft.com/en-us/ex...010338704.aspx