Removing Rows containing "#VALUE!"

Hi.
I've used a formula and copied it down long column in a data base. Some of the rows in the database lack the information needed for the formula to compute properly. These rows are marked with a "#VALUE!" where the other cells in the column would have the answer derived by the formula.

Is there a way I can remove the rows containing that error?

Trev-

I do not know about Mac, but in PC, you can use if errror function which you can return a zero, or other option you choose.

If only I had a newer version of Excel, that would be perfect.
Thanks though.

I made the assumption that as you have Mac 2010, you may have at least excel 2007.