Cleaning up a spreadsheet using functions?

Aloha,

I have a large data sheet.  I want to remove all lines of data that meet a certain parameter leaving me with the usable data.  How can I do this without manually going through each line?

Mahalo nui.