One caveat I forgot to include in my previous post, you need to enter that as
an array formula, so commit it with CTRL+SHIFT+ENTER.

--
Regards,
Dave


"Brandon" wrote:

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!