Top 5 formula that returns the content (text) of cell that EXCLUDES filtered/hidden cells

EDIT: I am not at all opposed to an entirely new formula -- whatever gets the job done.
Hi all,

I found this array formula lurking around the forums which generates the top 5 most frequent cells (text -- not numeric) in a range of data:

{=INDEX($B:$B,SMALL(IF(COUNTIF($B$2:$B$4312,$B$2:$B$4312)=LARGE(COUNTIF($B$2:$B$4312,$B$2:$B$4312),SUM(COUNTIF($B$2:$B$4312,$C$9:C10))+1),IF(ISNA(MATCH($B$2:$B$4312,$C$9:C10,0)),ROW($B$2:$B$4312))),1))}

It works perfectly, however it *includes* the hidden cells that have been filtered by Excel -- I need them excluded from the top 5 hits.

I need a formula (only a formula with my constraints -- no UDF or similar please) that will excludes any filtered out cells from the range above (B2 through B4312).

I have looked and have not been able to get a formula to do this although I believe SUBTOTAL and Offset are part of the mix, but I need some definitive formulas to try please!


Thanks so much in advance.