Count Unique IP Address in Google Sheet

I have a list of IP addresses in Col D

In Col A I've tried the following:

=SUM(IF(FREQUENCY(IF(LEN(D1:D52391)>0,MATCH(D1:D52391,D1:D52391,0),""), IF(LEN(D1:D52391)>0,MATCH(D1:D52391,D1:D52391,0),""))>0,1))

According to Microsofts KB its supposed to:

Count the number of unique text and number values in cells D1:D52391 , but do not count blank cells or text values.

Instead it only gives me a value of 1. For the above sample I would expect 3 and for my live data I would expect much more. Thanks.


The formula works (as mentioned by chris neilsen) as an Array formula, to enable this Array functionality you have to press Ctrl + Shift + Enter instead of simply Enter

Doing so will show 3 with your sample data.

Need Your Help

IllegalArgumentException: argument type mismatch in Hibernate

java hibernate orm

Out of the blue I started getting “IllegalArgumentException: argument type mismatch” in hibernate. The hibernate entity was working for quite some time and svn logs confirm the code to be intact.

Choppy Scrolling - Chrome

html css scroll vertical-scrolling

I'm having problems with choppy scrolling on my website. It's based on the "Porto" theme. Based on their site: DEMO, I can see that smooth scrolling is possible, but on my dev server: HERE

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.