retain only rows with condition that cells in column H containing"AU"

[Bora]

I have a large database containing columns with one column specifies
the product name. In one instances, I need to retain only rows with
condition that cells in column H containing "AU" of the entire string
in the cell. Delete those rows without it. The problem is , that the
AU of the string can appear in any position, not a fixed position.

Is there any simple way of doing it?

Many Thanks!

Regards,

Bora

 

[Shane Devenshire]

Hi,

You can use AutoFilter. Choose the command Data, Filter, AutoFilter. Then
open the autofilter drop down in the column H and choose Custom and from the
first drop down, top left side pick does not contain, and on the right type
in AU. Click OK. Select all the visible records and press del.

Remove the filter, you should have only the records you want.

If this helps, please click the Yes button,
Cheers,
Shane Devenshire

 

[Bora]

Wow, thank you Shane! It helps me saved a lot of time.

Regards,

Bora