LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting vs. filtering . . . HELP! Wayne Knazek Excel Discussion (Misc queries) 9 July 26th 06 12:36 AM
Deleting unused lines between used lines? Stevel Setting up and Configuration of Excel 1 November 25th 05 12:58 AM
Deleting Lines in Excel sibadee14 Excel Discussion (Misc queries) 1 November 16th 05 06:56 AM
Deleting multiple lines tammytlc Excel Discussion (Misc queries) 1 October 3rd 05 11:49 PM
Removing Print Lines Alex Excel Discussion (Misc queries) 2 May 20th 05 01:49 PM


All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"