LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default Row Deletion Question

I have a file with over 3 thousand line items. What I am trying to do is
delete an entire row based off an entry in column L. Example

Location Customer number
CA 23432
OR 13245
TX 45321
FL 43215

I want to search for 13245 & 45321 and delete those rows.

Or better yet would be to identify those I want to keep, 23432 and 43215,
and delete all other rows.

In this example the location column,as well as other entries in the file,
means nothing it was listed here because I felt two rows would show my
example better.

Thank you
Joe

 
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
name deletion rk0909 Excel Discussion (Misc queries) 2 January 4th 08 11:03 PM
simple row deletion lawson Excel Discussion (Misc queries) 3 October 17th 07 06:57 PM
Accidental Deletion Brian Frantz Setting up and Configuration of Excel 2 August 25th 06 08:51 AM
Sheet deletion mitch Excel Discussion (Misc queries) 4 August 19th 05 12:10 AM
#REF! after cell deletion Colin G Eastwood Excel Discussion (Misc queries) 1 December 2nd 04 01:22 PM


All times are GMT +1. The time now is 01:30 PM.

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"