There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

Do note that this action will remove the dashes in the entire Excel sheet. If you want to remove dashes from some particular cells, select those cells first and then use the Find and Replace feature.

This tutorial shows you how to fix and remove #DIV/0! error in Microsoft Excel by using the IFERROR or ISERROR function.