 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Row 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 Select A1 Data>Autofilter>Custom filter on column Customer number: not equal 23432 and not equal 43215 Edit>Jump(Ctrl+G)>Advanced...(bottom left button in the dialog box)>Current area Leave the selection unchanged Edit>Jump(Ctrl+G)>Advanced...(bottom left button in the dialog box)>Visible cells only Right click on the selected range>Delete row Warning! Unfortunately it'll delete also the header row, therefore save it in a separate sheet in order to copy it back when finished! Regards, Stefi „Joe” ezt írta: > 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 [quoted text clipped - 16 lines] > Thank you > Joe Stefi, Not sure where I have gone wrong but this is the third time I have tried to say thank you for your suggestion. However, even though I only identified two samples in my original post I need to be able to identify multiple customer ID to get rid of. I need to search for a certain ID the select and delete that entire row. The method you posted appears to be for only two selection and as I said I need multiple choice to search, identify, and then delete if the customer ID is present in the sheet. Thank you again. Joe > Select A1 > Data>Autofilter>Custom filter on column Customer number: not equal 23432 [quoted text clipped - 38 lines] >> Thank you >> Joe |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.