Hello,

I have a table that I need to list the most occurring text within a column. I always use the formula below with great results, but I now need this formula to recalculate when I apply filters to my table.
(My column is named "Company")

Here is my standard formula that I use for most occurring text:
PHP Code: 
=INDEX(A1:A100,MODE(IF(A1:A100<>0,MATCH(A1:A100,A1:A100,0)))) 
So I changed the cell range to "Table2[Company]" hit Ctrl + Shift + Enter. But unfortunately the formula is not recalculating when I apply filters to the table. It is still finding the most frequent text for the entire column table range.

Does anyone have any suggestions? I am probably missing something obvious here...


Thanks!
-Carl