How can I count the frequency that a number is repeated?

[arnie b]

I have a very large file, with repeated IP addresses in the same column. I
need to know how many times the same Ip address is repeated...

like 120.21.18.2 - repeated 630 times
156.44.90.5 - repeated 1023 times

appreciate any help -

 

[Max]

One thought. Use a pivot table. Follow the wizard. In step 3, click Layout,
then just drag the col label for IP addresses into both the ROW and DATA
areas. Finish up. The pivot results will return both a unique list of IPs
and the counts for each.