I am trying to write a formula that will give me the count of IP addesses in a table where the number of occurences of that IP is over 300. I would like to put that into a text box formula so that the figure is highlighted on my dashboard. I am able to display the actual list of IPs where this occurs with the formula below within a Pivot table that has IP selected as a dimension:
In the end there are 26 IPs out of about 3000 that come up over 300 times in the pivot, I would the textbox to display 26. Any help at all would be appreciated.