View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Joe[_9_] Joe[_9_] is offline
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