Excel Functions

Duplicate values within an Excel dataset might be useful at times. But they can also ruin calculations. In fact, for some numeric duplicate entries, Excel might generate wrong results.