I am working through a huge data set of fish lengths and weights. We discovered that some of the data appears to be invalid from a combo of user entry error and rounding issues. Is there a way that we can take all values that have a "zero" value in the hundredths place (The cell displays it as .10, however the zero is only there because of the formatting of the cell. True value of the cell = .1) and have them be removed?
Data I have:
Length Weight
2.3 .11
2.3 .1
2.4 .23
2.6 .1
2.7 .3
2.8 .21
What we want:
Length Weight
2.3 .11
2.4 .23
2.8 .21
Bookmarks