Removing (deleting, filtering) lines in a pattern . . .

[Guest]

Problem . . . File is imported. Only certain lines are needed. The data is
these 3 coluimns, 6 rows, repeated numerous times. (Column B is various text)

A B C
1 TE | |0.055
2 LE | |0.094
3 X | |.559
4 Y | |0.749
5 Z | |0.987
6 L | |0.296

What I need to do is show only this . . . (No X, Y or Z)

A B C
1 TE | |0.055
2 LE | |0.094
3 L | |0.296

Preferably . . . even better would be if all I got was this . . .

A B C
1 0.055
2 0.094
3 0.296

So I need to delete (or filter out, but a filter has already been run) all
rows with X, Y or Z in the 1st column.

 

[azafar]

Please try "text to column" wizard from Date menu to export data in to
excel. I hope it will work.
Thanks,
Abu Zafar

 

[Guest]

ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do as you wish...........

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

You could apply data|filter|autofilter to that first column.

Show the rows with X and delete them. Show the rows with Y and delete them.
And do the same with Z.

 

[Guest]

hey, Dave, that'sd exactly what I want to do. But I can't seem to figure out
how.

I already set up and ran one filter on all the data. That now leaves me
with the rows I showed in earlier post. When I try to set up another filter
for column A, it negates or deletes the filter I had in column D. (D is a
helper column)

 

[Dave Peterson]

You only get one data|filter|autofilter per worksheet--but you can include as
many columns as you want.

So either include all the columns (or just A) or remove the filter from D,
filter A, do the work, remove the filter from A and reapply it to D.

I'd filter on all the columns in the range. If I only ever use one of the
columns, it doesn't bother me.

 

[Guest]

I got it! Yazza. Makes total sense now.

Thanks TONS!

I'm gonna write a macro now to make it easier for the operators. Thanks
again!