Deleting rows matching a rule

Hi everyone,

I need to delete all rows which in the column G do not have a certain value.

I've got as well a header row which I don't want to be deleted.

Can anyone give me a hand?

Thanks and regards,

Can you explain a little more...What is the value you wish to keep.

If a cell contains "my value" i want to keep it?
Also the rows you want to remove will they all contain the same value or will they be different?

Hi Adam,

Thanks for your reply. I'll try to explain it a bit better.

I have a spreadsheet with my data in rows, I mean each record is one row and the columns are the different fields (amount, currency, date...).

One of the columns is currency, USD, EUR, GBP... What I want to do is to delete all the rows but the ones containing for example GBP.

Have you got an idea about I am trying to do?

Thanks and regards,

If i understand right, why not just autofilter?

Lets say all your currencies are in column A....
DATA > FILTER > AUTOFILTER

You can now select EUR from the drop down and delete them all
When you undo the filter, all the cells containing EUR would be gone?

Is this what you mean?