If you're like me, you have to deal with spreadsheets all the time that...
- Someone else created,
- Has dirty, unorganized, mixed-up data all over the place, and
- You have no other data source to get what you need.
What to do? Here's another instance where using ISERROR with IF can help you "flag" trouble spots for data cleaning.
Let's take the same data set as yesterday, two columns that we want to divide. In this case, however, there are some pesky text cells mixed in that are cramping our style.
We can "flag" those rows for cleaning with the formula,