Thread: How do I calculate the mode of a column of IP addresses?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brandon Brandon is offline
external usenet poster
  
Posts: 58
Default How do I calculate the mode of a column of IP addresses?
I've got a column of IP addresses in another worksheet. I want to find the
most common IP address, so I use this formula: =MODE('18th'!C:C) where "18th"
is the worksheet and C is the column for which I want the mode.

The result is #NUM!
Reply With QuoteReply With Quote