In article ,
says...
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!

IP addresses are a *string* of numbers and MODE ignores them.

Consider creating a PivotTable and using the 'Top {n}' option with n set to
1:

create the PT with the IP header as the row field and the data field. XL
will automatically create a COUNT(IP header) as the data field.

Double-click the row field header. Click Advanced... Set the 'Top 10
AutoShow' to 'On' and set the number next to Show Top to 1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions