Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing (deleting, filtering) lines in a pattern . . .
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting vs. filtering . . . HELP! | Excel Discussion (Misc queries) | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
Deleting multiple lines | Excel Discussion (Misc queries) | |||
Removing Print Lines | Excel Discussion (Misc queries) |