Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...

Duplicates in the same column are easy to find by sorting or filtering. Duplicates that span multiple columns require a bit of setup, but the solution's not difficult to implement. Finding duplicate ...