Removing (deleting, filtering) lines in a pattern . . .
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!
"Dave Peterson" wrote:
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:D) 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.
Wayne Knazek wrote:
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" wrote:
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.
Wayne Knazek wrote:
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.
--
Dave Peterson
--
Dave Peterson
|