possible? =if(That cell = "a certain word", delete row, go next)

Can Conditions include operative actions if true or false? such as:

If cell A7 = "Smith", delete row if yes, go to next cell if no ???

Jim

No, functions can only return a value, you will need a macro if you want
automated actions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"Jim" <[email protected]> wrote in message
news:[email protected]...
> Can Conditions include operative actions if true or false? such as:
>
> If cell A7 = "Smith", delete row if yes, go to next cell if no ???
>

Jim,
You need to use VBA to do this.

Deletes any row containing Smith in column A .... must start at last row and
work upwards

Sub DeleteRow()
e.g For r = 100 to 1 step -1
If cells(r,1)=Ucase("Smith") then
cell(r,1).entirerow.delete
End if
Next r
End sub

"Jim" wrote:

> Can Conditions include operative actions if true or false? such as:
>
> If cell A7 = "Smith", delete row if yes, go to next cell if no ???
>