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.