Count Unique IP Address in Google Sheet
I have a list of IP addresses in Col D
184.108.40.206 220.127.116.11 18.104.22.168 22.214.171.124 126.96.36.199 188.8.131.52 184.108.40.206 220.127.116.11 18.104.22.168 22.214.171.124
In Col A I've tried the following:
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.