Can we removing particular rows of data thru formulas?

Hello All,

We have an Excel document that contains rows of data we would like to remove and would like to find out if we can use a formula to remove the unwanted rows of data. All of these rows contain a keyword in a particular cell in column A. For example if cell A1, A5, A10, A20, A98 contains the word “cat” we would like to remove the entire row. We have approx 1000+ rows that would need to be removed and they are disbursed throughout the Excel document. Do you guys know of a formula that can do this? I am sure there is a way but I don’t know how.

Thanks again for your help,

gsmonk

See link

http://www.rondebruin.nl/delete.htm#Find

VBA Noob

If you mean that you want to delete the entire row for any amount Less Than or Equal to 9.99.....You could use an AutoFilter:

With Col_A containing amounts and
A1: Amount

Select from A1 through the bottom of your list

Then....from the Excel Main Menu
<data><filter><autofilter>
Click the DropDown on A1
Select: Custom
Amount: Is Less than or Equal To: 9.99
Click [OK]
(Only those cells will be displayed..the others will be hidden)

Select from the first displayed row below A1 through the last displayed row.
Press the [delete] key....When AutoFilter is engaged....You can only delete entire rows.

The turn off the AutoFilter and the remaining rows will still be there.

Is that something you can work with? or do you need something else?

gsmonk,

Please don't post duplicate threads as they may be deleted next time

VBA Noob