Count Unique IP Address in Google Sheet

I have a list of IP addresses in Col D

97.101.229.32
97.101.229.32
97.101.229.32
64.120.50.157
54.252.36.98
54.252.36.98
54.252.36.98
54.252.36.98
54.252.36.98
54.252.36.98

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.

Answers


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