Delete entries which appear 3 or more times in a column

**Kaylimoo** · 02-08-2011, 07:21 AM

Hi,
I have a list of IP addresses and need to delete those which appear 3 or more times, leaving me with a list of IPs that appear less often.

Not sure if it's of any relevance, but IP format is: 123.456.789

Hope this makes sense as I have read many other posts and couldn't quite get the info that I needed.

Kayleigh

**Rahul Nagar** · 02-08-2011, 07:24 AM

Hi,
Use countif function.
if you data is in column A1 put this formula in Bcolumn
=COUNTIF(A1:A495,A1)

**Kaylimoo** · 02-08-2011, 07:33 AM

Hi,
Thanks for you reply Rahul.
I have tried this in B column, with data in A column and this just gives me a solution of 1.
Am I doing something wrong here ?