Thread: How can I count the frequency that a number is repeated?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arnie b arnie b is offline
external usenet poster
  
Posts: 1
Default How can I count the frequency that a number is repeated?
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 -


Reply With QuoteReply With Quote