Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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:
=if(sum(recordcount)>300,count(IP))
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.
Thanks.
SS
In a text box, try
=COUNT({< IP = {"=count(IP)>300"} >} DISTINCT IP)
That was just what I needed. Thanks for the quick help.